Forum Discussion

Frequent Visitor

3 years ago

Solved

PREVIOUSMONTH() function does not working for me

Hi, I have written PREVIOUSMONTH() in below measure: Previous Month Sales = VAR vSales = CALCULATE( sum(Orders[Sales]), PREVIOUSMONTH('Calendar'[Date]) ) RETURN IF(vSales = blank(), 0, vSale...

Need Help

gsandip
3 years ago
Hi,
I got the solution here By amitchandak
(1) Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, YOY - YouTube
I have used below DAX and it works fine for me.
Previous Month Sales = CALCULATE ( SUM ( Orders [Sales] ), OFFSET (- 1 , ALLSELECTED ( 'Orders' [Month Name] , Orders [Month Num] ), ORDERBY ( 'Orders' [Month Num] , ASC ), KEEP ) )

Great Help
Thank you,
Sandip Ghosh

gsandip

Frequent Visitor

3 years ago

Hi,

I don't understand it, can you please give me the syntax or modified DAX what I was using?

gsandip

Frequent Visitor

3 years ago

Hi,

I got the solution here By amitchandak

(1) Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, YOY - YouTube

I have used below DAX and it works fine for me.

Previous Month Sales = CALCULATE ( SUM ( Orders [Sales] ), OFFSET (- 1 , ALLSELECTED ( 'Orders' [Month Name] , Orders [Month Num] ), ORDERBY ( 'Orders' [Month Num] , ASC ), KEEP ) )

Great Help

Thank you,

Sandip Ghosh

Forum Discussion

PREVIOUSMONTH() function does not working for me

Related content

PREVIOUSMONTH

PREVIOUSMONTH DAX Function

PREVIOUSMONTH not work

Function DATESINPERIOD doesn't work properly

PREVIOUSMONTH Query