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 NextDay. The expression below uses FactInternetSales to create a table of all dates from the next day to the first date in the OrderDate column. Please refer to the DAX DAY and DAX PREVIOUSDAY functions.
To show the same, please add the OrderDate, NextDay, Order Quantity, and Sales Amount to the table report. For the remaining charts, visit the Power BI Charts article.
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. Please refer to the list of Power BI DAX Date and Time functions and the Power BI DAX functions article available on the Power BI tutorial for beginners page for the remaining methods.
NextDaySales = CALCULATE(SUM(FactInternetSales[SalesAmount]), NEXTDAY(FactInternetSales[OrderDate])
