The Power BI DATESQTD function is one of the DAX Date and Time functions useful to return a table that contains continuous dates for the quarter to date. For the DATESQTD function, you can use the column that contains the date/time value. Otherwise, use the table expression that returns a single column as the parameter.
This article explains the POWER BI DAX DATESQTD function that accepts the value of the date and uses the current context to return a column of dates for the quarter to date and the syntax is shown below.
DATESQTD(<dates>)
Power BI DAX DATESQTD function Example
The expression below uses the FactInternetSales table OrderDate column to create a table with dates for the quarter. Please refer to the DAX DATESMTD and DAX DATESYTD functions.
Table = DATESQTD(FactInternetSales[OrderDate])
To demonstrate the DAX DATESQTD() function, click the New Measure button on the Modeling Tab and rename it as RunSalesQTD. The below expression calculates the sum of the Sales Amount in the FactInternetSales table for each quarter. Here, we used the CalendarTable generated by the DAX CALENDAR function. Please refer to the list of DAX Date functions and the all DAX functions article available on the Power BI tutorial page for the remaining methods.
If we add the below expression to the table it will calculate the running total for each quarter of the Order date and restart at the next quarter. Please check the Qtr 1 and Qtr 2 in the below table report. For the remaining charts, visit the Power BI Charts article.
RunSalesQTD = CALCULATE(SUM(FactInternetSales[SalesAmount]), DATESQTD(CalendarTable[Date]))
In the below expression, we used the FILTER method to restrict the use of DATESQTD for the first quarter. This formula calculates the running total of the first quarter in each calendar year.
RunSalesQTDQtr1 = CALCULATE(SUM(FactInternetSales[SalesAmount]), DATESQTD(CalendarTable[Date]), FILTER(CalendarTable, CalendarTable[Date].[Quarter] = "Qtr 1"))
