How to Calculate Cumulative Total with DAX in Power BI
Vložit
- čas přidán 22. 09. 2022
- 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.microsoft.com/en-us/d...
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 👉 czcams.com/users/EssentialExcel
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 💯 ..
Amazing, worked first time. Thank you. Well explained and easy to follow.
Great video - simple examples no mucking about. The Calendar table tip was the part missing from every other example of this
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 😊
Man, thank you so much. I was working on the same task more than 7 days to do it.
Thanks a lot! You solved my puzzle that I could not solve for 3 days😊
Thank you so much for the video!
Thank you very much !!!!
Very very useful. Thanks
you saved me, thank you very much!
Glad to help 😃
Good idea, thank you :)
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 🙂
awesome
Very helpful. This solved a coworker's problem for me.
Thanks Mike! Glad it helped 🙂
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 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?
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
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!
Thanks
Hi! can you please explain how to add a second cumulative measure for STLY?
THANKS GOD
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
Fucking hell what a video. U're the man brother
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
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.
Very helpful thank you
Thank you Karen! 🙂