NEXTMONTH DAX Function

The NEXTMONTH time-intelligence function returns a table that contains a single column of all dates from the next month, based on the first date in the dates column in the current context.

For example, if the first date in the dates argument refers to June 10, 2009; then this function returns all dates for the month of July, 2009 i.e., from 1st July to 31st of July, 2009.

DAX Syntax NEXTMONTH(dates)

The parameter "dates" is a column containing dates.

Example: The following expression creates a measure that calculates the next month income.

DAX

Sum of next month income = CALCULATE(SUM(Sheet8[Annual Income]), NEXTMONTH('Sheet8'[Year]))
NEXTMONTH dax function