Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I would like to calculate the measure Rolling 12 Month Spend.
I need this measure by month, the figure of each month should be (current month + the previous 11 months).
For example, row 13 should be the sum of B2 to B13, row 14 should be the sum of B3 to B14 and so on, the silcer should not change this calculation.
Solved! Go to Solution.
Share the download link of the PBI file.
Thanks @Ashish_Mathur , but it is showing the just the monthly amount.
I think the problem is the calendar table is not a date table.
You have obviously not chacked the file that i uploaded. Study that carefully.
I have, and I have used the DAX you have provided before, so it is not new.
I am not sure what do you mean by Study that carefully.
As you can see in the screenshot, my solution is working fine. I do not know the mistake that you are committing in your file. Check the relationship.
this is my measure:
Share the download link of the PBI file.
User | Count |
---|---|
106 | |
90 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |