Forum Discussion
Need help: DAX Previous Month Comparison
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 c...
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!
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