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 below expression calculate and show the sum of the Sales Amount of the next OrderDate quarter in the FactInternetSales. 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.
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 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. Please refer to the DateTime and function article for the remaining Power BI methods. For more Charts >> Click Here.
NextQTRCalSale = CALCULATE(SUM(FactInternetSales[SalesAmount]), NEXTQUARTER(CalendarTable[Date]))
