Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
55 | |
54 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
40 |