Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |