DATESQTD DAX Function

The function returns a table that contains a single column of the dates for the quarter to date, in the current context. For example, if the first date in the column is 7 Aug 2008, then it returns all the dates from 1st July 2008 to 30th Sep 2008.

DATESQTD dax function

DAX Syntax DATESQTD(dates)

The parameter dates is a column containing dates.

Example: The following sample formula creates a measure.

DAX

The DatesQTD function = CALCULATE(SUM(Sheet8[Annual Income]), DATESQTD('Sheet8'[Year]))
Previous Next