Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am using the below dax query to get previous month sum of the data.
Solved! Go to Solution.
You can try something like below.
Consumption Dollars PM = CALCULATE([Consumption Dollars],PARALLELPERIOD(DimDate[FullDateAlternateKey],-COUNTROWS(ALLSELECTED(DimDate[EnglishMonthName])),MONTH))
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
You can try something like below.
Consumption Dollars PM = CALCULATE([Consumption Dollars],PARALLELPERIOD(DimDate[FullDateAlternateKey],-COUNTROWS(ALLSELECTED(DimDate[EnglishMonthName])),MONTH))
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
User | Count |
---|---|
91 | |
77 | |
71 | |
64 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
60 |