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 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:
6 Replies
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
Uzi2019Community Champion
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.
