Downloads
DAXTime intelligence: shift and compareIntermediate

PREVIOUSMONTH

Returns all the dates of the month before the first date in the filter context.

Syntax
PREVIOUSMONTH(<dates>)

Returns: A table of dates.

What it does

PREVIOUSMONTH returns every date in the month before the one in context. Inside CALCULATE, a measure shows the whole of last month's figure, whatever part of the current month is visible. Finance teams use it for month-over-month growth, for the prior month's accruals that reverse in the current month, and for last month's expenses in a variance review.

Syntax and arguments

Example

A monthly sales report compares each month with the month before. The measure returns the full prior month, so a row for October shows all of September.

Revenue Last Month = CALCULATE([Total Revenue], PREVIOUSMONTH('Calendar'[Date]))

Revenue MoM % = DIVIDE([Total Revenue] - [Revenue Last Month], [Revenue Last Month])

In the October 2026 row, Revenue Last Month adds up every day of September 2026. The growth rate compares the two full months.

Example: a second, different use

Accruals booked at the end of last month that reverse in the current month. The reversal amount is the total of last month's accruals.

Accrual Reversal This Month =
CALCULATE(
    SUM('Accruals'[Amount]),
    PREVIOUSMONTH('Calendar'[Date]),
    'Accruals'[Status] = "Open"
)

Things to watch

In business terms

PREVIOUSMONTH supports month-over-month sales reviews, accrual reversal checks at the start of the close, and the prior month variance commentary that controllers give to management. It answers "what happened last month?" in one line.

Related functions

All DAX functions · View as Markdown · DAX fundamentals