Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I am locking for a way to calculate / display a cumulative Sum. See the red line below:
Sadly, I was not able to find a solution. Has anyone an idea on how this would work?
Thanks
Hi @Markus_P ,
Create measure
Cumulative Total = CALCULATE( SUM('Table'[Wert]), FILTER( ALL('Table'), 'Table'[Date] <= MAX('Dimdate'[Date]) ) )
Then add Cumulative Total on Y-axis and date on X-axis.
Thanks
This Works, Tanks.
I was wondering if there is a way to do this when my filter are no Values and are not in an Alphabetical Order. Therefore, I wand to use a custom order. I can create a second column that has a ranking information. But I use this then I can’t show the “real” Date in the visual.
@Markus_P See this video for a running total:
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |