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
Hello All,
I currently have the following data in table form. I need to have the monthly totals as a rolling total and visualize it. Eg: August would show 23+3569 and September will show 23+3569+23687.
Current Visual
Expected visual (example)
Thank you in advance
Solved! Go to Solution.
Hi @Mewan117 ,
Please try:
Cumulative = CALCULATE (
DISTINCTCOUNT(Total[orderId]), FILTER (ALLSELECTED(Total),[Date]<=MAX('Total'[Date])))
Corrcet Total of Cumulative =
var _t= SUMMARIZE('Total',[Date],"Cum",[Cumulative])
return IF(HASONEVALUE(Total[Date]),[Cumulative], SUMX(_t,[Cum]))
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Mewan117 ,
Please try:
Cumulative = CALCULATE (
DISTINCTCOUNT(Total[orderId]), FILTER (ALLSELECTED(Total),[Date]<=MAX('Total'[Date])))
Corrcet Total of Cumulative =
var _t= SUMMARIZE('Total',[Date],"Cum",[Cumulative])
return IF(HASONEVALUE(Total[Date]),[Cumulative], SUMX(_t,[Cum]))
Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
try this :
Combine first month and year on new column
example new column name : MonthYear
and then
Running Total = Calculate(SUM('Table1'[count of orderid]), filter(allselected('Table1'),'table1'[MonthYear] <= MAX('table1'[MonthYear])))
@tevisyauw Thank you for your response. That code didn't work, unfortunately. But I was able to use the following to get this output
But the totals are wrong. Also, my other slicers don't work. Eg below
It should only show the running total of the months that the slicer applies right? Eg for June it should be 76902+144373?
@Mewan117
For Slicer usually I make new table with Calendar Date
@tevisyauw It didn't work. It gave me some strange numbers. I got close with this code
Example of one that doesn't work
I haven't figured out why this is happening.
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 |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
106 | |
64 | |
60 |