DATESQTD DAX Function in Power BI
The DATESQTD DAX function returns a table that contains a single column of the dates for the quarter to date, in the current context. For example, if in the current context the returned date value is 7 Aug 2008, then it returns all the dates from 1st July 2008 to 30th Sep 2008, provided those dates are available in the given dates column.
DAX Syntax DATESQTD(dates)
The parameter dates is a column containing dates.
Example: Let’s we have the following table named Sheet1 and we have Dates column in it with Date data type.
Let’s create a measure with name DATESQTD Measure.
DAX
DATESQTD Measure = CALCULATE(SUM(Sheet1[10th Marks]), DATESQTD(Sheet1[Dates]))
The output of the above dax function is shown below:
Note: The value 2786 is the latest quarter to date value i.e. for the date 14th August 1991.