Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to create a line chart that shows cumulative sales for both the month selected by a slicer and the previous month. I have built a measure for cumulative sales for the current month that works correctly, the measure is:
How can I get the prior month measure to give me a cumulative sum for each day, like the current month measure?
Solved! Go to Solution.
Hi @crobson29
You can use this measure for previous month
Previous Month = CALCULATE(SUM(VW_FACT_SALES_DOCUMENT_ITEM_DATA_USA[Weight (Gallons)]),DATEADD(DATESMTD('M_CALENDAR_BILLING'[Date]),-1,MONTH))
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
This is exactly what I was going for, Thank you!
Hi @crobson29
You can use this measure for previous month
Previous Month = CALCULATE(SUM(VW_FACT_SALES_DOCUMENT_ITEM_DATA_USA[Weight (Gallons)]),DATEADD(DATESMTD('M_CALENDAR_BILLING'[Date]),-1,MONTH))
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!