How to Calculate Cumulative Total with DAX in Power BI
Вставка
- Опубліковано 6 лют 2025
- Do you need to know how to calculate cumulative total with DAX in Power BI?
In this Power BI Tutorial we demonstrate how to create a measure with DAX to calculate your cumulative total and present in a line chart. Cumulative totals are an effective way to improve your visuals and demonstrate how a value accumulated over a period of time.
WHAT IS POWER BI?
Power BI is a business intelligence tool provided by Microsoft for analysing and visualising data providing both you and your customers with more meaning insights. If you are familiar with using Microsoft Excel then Power BI is the progression you need to take your reporting to the next level.
Get started today by downloading the application for free:
powerbi.micros...
If you enjoyed this tutorial do not forget to give the video a like and subscribe from more content!
Have a question? Please drop me a comment below and I will respond as soon as possible.
MORE TUTORIALS
/ essentialexcel
#excel #vba #tutorial #msexcel #macros #visualbasic
I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!
For More 👉 ua-cam.com/users/EssentialExcel
Man, thank you so much. I was working on the same task more than 7 days to do it.
Oh my word ... Was just searching and stumbled upon this and I positively and figuratively LOVE YOU 🕺... Just this small n precise to the point video and explanation with such meaningful simplicity, you ARE a boon Mr. Essential Excel ... Subscribed to this beautiful channel... So much love and support from Madhya Pradesh, India 💯 ..
Very helpful. This solved a coworker's problem for me.
Thanks Mike! Glad it helped 🙂
you are a genius and a great teacher, this combo is rare.
Thank you so much for this video, have been struggling to do this today and you have shown me in less than 7 mins 😊
Amazing, worked first time. Thank you. Well explained and easy to follow.
Thanks a lot! You solved my puzzle that I could not solve for 3 days😊
tnks from Brazil man
Great video! Thank you for this.
What if you wanted to do a cumulative sum by week? Say the week ends on Saturday and we want the running sum at each consecutive Saturday.
Great video - simple examples no mucking about. The Calendar table tip was the part missing from every other example of this
Very very useful. Thanks
Exactly what I was looking for!!
Thank you so much for the video!
Thanks for the video - I don't know what I am doing wrong. I seem to get the grand total showing up as the same for every month rather than it increasing cumulatively. Any idea why that could be? I have my calendar table and it has a relationship with all my data tables. Thank you
What field are u using for ur x-axis?
Did you ever find a solution to this?
Really useful. Thanks
you could also use easily the year to date function. Which does the same thing
Thank you very much !!!!
Very helpful thank you
Thank you Karen! 🙂
you saved me, thank you very much!
Glad to help 😃
Good idea, thank you :)
Hi! can you please explain how to add a second cumulative measure for STLY?
I like this! Thank you! I don't know if I can get the data you used. I'd appreciate it
very well explained, thanks
Thank you Costly 🙂
I am stuck on this problem, "Products contributing in 50% of Total Sale for selected Year and Sub-category…" on Product Sales data
Great video. Thank you. Very clear. Is there a possibility to do subtraction by date, like showing how we loosing money per date with similar function?
THANKS GOD
I need to do the exact same thing but with amount of projects per fiscal year instead of $ per date... How would I do that??? Thank you!
Hi the measure works for me but if I add another field for filter lets say Country then the cumulative sum stops working and it just sums up the date where there is data
Thanks
How would you create this if you wanted say just previous 14 days rolling? so day 1 effectively the base number 0, cumulative just those 14 days? I've tried a few ways including creating a seperate 14 day calendar, but still gives me the overall run rate and not just the selected 14 days. Any help on that would be great. Great video aswell
awesome
I'm getting an error that says, "Visual has exceeded the available resources." Any idea what I did wrong?
I believe I figured out that error, but now it's displaying my chart as a flat line with no change over time. Any suggestions?
Thanks to you, but could you please give us sample how to reverse from cumulative become monthly/daily. I hope you don't mind to help, thank you very much
Hello 👋 Happy to help however not sure I understand your question… as you would need monthly/daily to create you cumulative?
i have sales data in cumulative per month : Jan 100, Feb 200 (100+100), March 300 (100+100+100), Apr 400 (100+100+100+100).
I want to change these data become monthly sales : jan 100 (100), Feb 100 (200-100), March 100 (300-200), April 100 (400-100).
Could you please tell me how to do it ? Thank you@@EssentialExcel
i have sales data in cumulative per month : Jan 100, Feb 200 (100+100), March 300 (100+100+100), Apr 400 (100+100+100+100).
I want to change these data become monthly sales : jan 100 (100), Feb 100 (200-100), March 100 (300-200), April 100 (400-100).
Could you please tell me how to do it ? Thank you @EssentialExcel@@EssentialExcel
Fucking hell what a video. U're the man brother
the line is coming straight however I followed each step🙄
Having the same issue, did you find a resulution?
Have the same problem. Cannot figure out what was wrong
Had the same problem. When I had the straight line I first deleted the date from the X-axis. Then I added the date to the X-axis again. That solved it for me. Hope this helps anyone who is struggling with the same issue.
Did you ever find a solution to this?