The Power BI NEXTDAY function is one of the DAX Date and Time functions useful to return a table that contains all dates from the next day based on the given date. This article explains the POWER BI DAX NEXTDAY function that accepts the date’s value and uses the current context to return a column of all dates from the next day to the first date and the syntax is shown below.
NEXTDAY(<dates>)
Power BI DAX NEXTDAY function Example
To demonstrate the DAX NEXTDAY() function, click the New Table button on the Modeling Tab and rename it as NextDay. The below expression uses FactInternetSales to create a table of all dates from the next day to the first date in the OrderDate column.
To show the same, please add the OrderDate, NextDay, Order Quantity, and Sales Amount to the table report. Please refer to the DateTime and the function article for the remaining Power BI methods. For more Charts >> Click Here.
NextDay = NEXTDAY(FactInternetSales[OrderDate]
The below expression creates a simple measure. It will calculate and show the sum of the Sales Amount of the next OrderDate day in the FactInternetSales table. We will compare both present-day sales against the next day sales. To do so, let’s add the OrderDate, Sales Amount, and the sum of the next day sales to the table.
NextDaySales = CALCULATE(SUM(FactInternetSales[SalesAmount]), NEXTDAY(FactInternetSales[OrderDate])
