Need help: DAX Previous Month Comparison

[Aravind24]

Hi All,

I am trying to compare the Month on Month comparison for the year 2024. However my datasource has data from 2023. Dye to whichm Jan'24 is comparing value with Dec'23. I dont need Jan'24 comparison with Dec'23. Kindly help. I use date table.

Requesting to kindly help with excluding the comparison for Dec'23. 

Query:

SAAS_OPS_Inflow_MOM =

CALCULATE([SAAS_OPS_Overall_Inflow],

PREVIOUSMONTH('Date'[Date]), REMOVEFILTERS('Date'))

Output:

[Uzi2019]

Hi @Aravind24 

What should be expected output?
can you share via excel screenshot for better understanding.

[Uzi2019]

Hi @Aravind24 

I dont understand why you are getting 20 in all values as i dont know the your modeling. As you can see in my screnshot i am getting correct result what you are expecting. 

I just connect my date filed with Calendar date table. and I also created month year column which is date data type

Please check your modeling.

[Aravind24]

https://docs.google.com/document/d/1fLK2GSQlSfDH6yRkZAwcBCDsvxgjOT-M/edit?usp=sharing&ouid=108090676... 

Please check uploaded here

[Uzi2019]

Hi @Aravind24 
If you want only 2024 years data then use this dax as Measure

Previous Month =

CALCULATE(SUM(Lumix[Clicks]),DATEADD('Calendar'[Date],-1,MONTH), YEAR('Calendar'[Date])=YEAR(TODAY()))

I hope I answered your question!

[Aravind24]

Hello Thanks for the quick response.

Its not working.

SAAS_OPS_Inflow_MOM =

CALCULATE([SAAS_OPS_Overall_Inflow],

DATEADD('Date'[Date], -1, MONTH), YEAR('Date'[Date]) =YEAR(TODAY()))

Its unable to get the value for previous year only

[Aravind24]

@Ritaf1983  @DU  @mussaenda  -- please help experts