Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
118 | |
72 | |
71 | |
57 | |
49 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |