Home » DAX » NEXTDAY DAX

NEXTDAY DAX

Nextday Dax function

NEXTDAY DAX function returns a table that contains a column of all dates from the next day, based on the first date specified in the dates column in the current context.

It’s comes under Time Intelligence DAX function category.

Syntax

NEXTDAY(Dates)

Parameters

Dates : A column containing dates.



Note:  The dates argument can be any of the following:

  1. A reference to a date/time column.
  2. A table expression that returns a single column of date/time values.
  3. A Boolean expression that defines a single-column table of date/time values.
  4. This function doesn’t support direct query mode.

So, Let’s start with an example, download the sample Dataset from below link-

Following these steps-

Step-1: Create one measure to get next day sales.

NextDaySales =

CALCULATE(SUM(Orders[Sales]),
NEXTDAY(Orders[Order Date])
)

Step-2: Now drag the measure to table visual with date column.

As you can see below given screen shot- For 1 Jan 2012 next day sale is 314.22, because that is 2 Jan 2012 Sales.

Note: Make sure date column should be in ASC order to verify the sales.

Nextday Dax

Nextday Dax

Refer more DAX function – DAX Tutorials




Leave a Reply