ENDOFQUARTER DAX Function

The ENDOFQUARTER time-intelligence function returns a table containing a single column and single row with a date value, which specifies the last date of the quarter in the current context for the specified column of dates. For example, if the first input date is 7th May 2008, then the end_of_quarter is 30th June 2008.

ENDOFQUARTER dax function

DAX Syntax ENDOFQUARTER(dates)

The parameter dates is a column containing dates.

Example: The following expression creates a measure that returns the end of the quarter, for the current context.

DAX

The endofquarter function = CALCULATE(SUM(Sheet8[Annual Income]), ENDOFQUARTER('Sheet8'[Year]))
ENDOFQUARTER dax function
Previous Next