Forum Discussion
Current Month and Prior Month (Table, Funnel and Cards)
Hi Folks, I need help to create a DAX Measures for Prior Month's value to display in Tables & Funnels and Cards visuals. I tried with 2 measures without success. Prior Month 1 = CALCULATE(SUM(...
Hi amitchandak - thank you for responding to my post. I tried the "last month sales" DAX without success.
Using your recommendation, the DAX is as follow
Prior Month = CALCULATE(SUM(Table1[Opportunity Value]),PREVIOUSMONTH('Date'[Date]))
There is no value in the visual.
- amitchandak
Super User
PowerNooby , when you use PREVIOUSMONTH , it takes the min date from the context. So if there is filter context min date in the filter. Or Min date from ROW.
If there is no date then it will take Min date from Date table.
Now is there a previous month data based row, filter or tables min date ?
Refer if needed
Why previousmonth does not give result when datesmtd is giving it: https://youtu.be/1KkoJehRVeg
