The Power BI NEXTQUARTER function is one of the DAX Date and Time functions useful to return a table that contains all dates from the next quarter based on the first date of a given date. This article explains the POWER BI DAX NEXTQUARTER function that accepts the dates value and uses the current context to return a column of all dates from the next quarter and the syntax is shown below.
NEXTQUARTER(<dates>)
Power BI DAX NEXTQUARTER function Example
To demonstrate the DAX NEXTQUARTER() function, click the New Table button on the Modeling Tab and rename it as NEXTQUARTER. The expression below calculates and shows the sum of the Sales Amount of the next OrderDate quarter in the FactInternetSales. Refer to the DAX PREVIOUSQUARTER function.
Please check the sales of the 31-12-2010 and 01-01-2011 dates. Here, 14,21,357.42 is the last quarter 2010 sum of the sales, and 18,01,595.143 is the 2011 first quarter sales. Please refer to the list of Power BI DAX Date functions and the Power BI DAX functions article available on the Power BI tutorial page for the remaining methods.
NextQuarterSales = CALCULATE(SUM(FactInternetSales[SalesAmount]), NEXTQUARTER(FactInternetSales[OrderDate]))
The below expression creates a simple measure. It calculates the sum of the Sales Amount of the next quarter based on table generated by the DAX CALENDAR function.
To compare both present quarter sales against the next quarter sales, we have added the Year & Quarter of OrderDate, Sales Amount, and the sum of the next quarter sales to the table report. For the remaining charts, visit the Power BI Charts article.
NextQTRCalSale = CALCULATE(SUM(FactInternetSales[SalesAmount]), NEXTQUARTER(CalendarTable[Date]))
