ENDOFMONTH DAX Function (Time Intelligence) Context Transition
Returns the end of month.
Syntax
ENDOFMONTH ( <Dates> )
| Parameter | Attributes | Description |
|---|---|---|
| Dates |
The name of a column containing dates or a one column table containing dates. |
Return values
Table A table with a single column.
A table containing a single column and single row with a date value.
Remarks
The dates argument can be any of the following:
- A reference to a date/time column. Only in this case a context transition applies because the column reference is replaced by
- CALCULATETABLE ( DISTINCT ( <Dates> ) )
- A table expression that returns a single column of date/time values.
- A Boolean expression that defines a single-column table of date/time values (when used in a CALCULATE filter argument).
The result table includes only a date that exists in the dates column.
Related functions
Other related functions are:
Last update: Oct 13, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/endofmonth-function-dax