Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi
Can someone please help with my problem
Im trying to find the cumulative running total for each month, i.e. Cumulative for sept is 100 then oct as 240...
I know how to do the cumulative with Earlier - which is
The data is as follows:
Month | Revenue | Cumulative |
Sept | 100 | |
Oct | 140 | |
Nov | 100 | |
Dec | 200 | |
Jan | 200 | |
Feb | 232 | |
Mar | 231 | |
April | 123 | |
May | 123 | |
June | 543 | |
July | 211 | |
Aug | 432 |
Solved! Go to Solution.
Try adding something, either a calculated column or a separate table you can relate to your current data, that assigns the value 1 to Sept, 2 to Oct etc, which you can then order by and utilise in your formula
If you have a dedicated date table and it is marked as such, you can use the builtin time-intelligence:
TOTALYTD Measure Here= /*------------------------------------------------------------------------- 'Simple calculation when do not need further complex filtering' 'Use the Date/Calendar Table and Date Key' 'Be sure that the Date Table is set as a date table' --------------------------------------------------------------------------*/ TOTALYTD ( [Measure Here] , Date[DateKey] ',Optional Fiscal Year End')
Try adding something, either a calculated column or a separate table you can relate to your current data, that assigns the value 1 to Sept, 2 to Oct etc, which you can then order by and utilise in your formula
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |