DAX for calculating previous month sales without date column

Hello Dhruvin !

I would recommend that you add a proper date column in your case, meanwhile you need to capture the selected year or month context from your table or slicer and if month= 1, you go to December of the previous year otherwise, you just subtract 1 from the current month.

If you need a running trend across monthsit’s better to create a YearMonth key (like 202501) and calculate relative offsets using MAX or MIN or a proper date table.

Previous Month Sales =
VAR CurrentYear  = SELECTEDVALUE ( Sales[Year] )
VAR CurrentMonth = SELECTEDVALUE ( Sales[Month] )
VAR PrevYear =
    IF ( CurrentMonth = 1, CurrentYear - 1, CurrentYear )
VAR PrevMonth =
    IF ( CurrentMonth = 1, 12, CurrentMonth - 1 )
RETURN
CALCULATE (
    SUM ( Sales[SalesAmount] ),
    Sales[Year] = PrevYear,
    Sales[Month] = PrevMonth
)

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amira Bedhiafi11mo ago
Hello Dhruvin !

I would recommend that you add a proper date column in your case, meanwhile you need to capture the selected year or month context from your table or slicer and if month= 1, you go to December of the previous year otherwise, you just subtract 1 from the current month.

If you need a running trend across monthsit’s better to create a YearMonth key (like 202501) and calculate relative offsets using MAX or MIN or a proper date table.
```
Previous Month Sales =
VAR CurrentYear  = SELECTEDVALUE ( Sales[Year] )
VAR CurrentMonth = SELECTEDVALUE ( Sales[Month] )
VAR PrevYear =
    IF ( CurrentMonth = 1, CurrentYear - 1, CurrentYear )
VAR PrevMonth =
    IF ( CurrentMonth = 1, 12, CurrentMonth - 1 )
RETURN
CALCULATE (
    SUM ( Sales[SalesAmount] ),
    Sales[Year] = PrevYear,
    Sales[Month] = PrevMonth
)
```
0