PREVIOUSMONTH DAX Function

The PREVIOUSMONTH time-intelligence function returns a table that contains a single column of all dates from the previous 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, this function returns all dates for the month of May, 2009 i.e., from 1st May 2009 to 31st May 2009.

DAX Syntax PREVIOUSMONTH(Dates)

The parameter Dates is a column containing dates.

Example: The following sample formula creates a measure that calculates the previous month income.

DAX