NEXTMONTH DAX

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

It belongs to the Time Intelligence function category in DAX.

Syntax:

NEXTMONTH(Dates)

Parameter

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-

• Global Super Store Dataset

Following these steps-

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

NextMonthSales =

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

Step-2: Now drag that measure to Table visual with date field and see the result.

As you can see in the screen shot above, the sales for February 2012 is 103718, so the Next month sales for whole January 2012 will be 103718, which you can see in the table on the right.

Refer more DAX function – DAX Tutorials