Running Total or Cumulative Total of Non Date Columns - Power BI DAX Tutorial (29/50)

[@ratanbhushan8839]

This is the second time I have stucked in PowerBI in such a way that for last 4-5 days no one has been able to solve my problem related to running total for non-date columns. But bro - your this video, I watched only once, and it worked like anything for me. Thank you champ.. thanks a ton. I just joined your telegram channel. Thanks again

[@AnalyticswithNags]

Glad I could help, Keep Learning and Sharing.

[@PraxeoIogy]

Did you ever make a video showing how to integrate rank to get a cumulative sorted based on the total? Very informative videos!

[@AnalyticswithNags]

Not sure about your question. This may be the video you are looking for kzbin.info/www/bejne/f5-0Y5KCibtrec0

[@ashu60071]

I like the beginning music. So soothing 😊

[@AnalyticswithNags]

Thank you

[@NasirUddin-op7it]

Hi, i have a data set of 17mio rows where there is not date column. I've written a DAX measure for running total of the values. Same measure works file with small data set But it takes huge time to execute in this 17mio data set. DAX is CALCULATE( SUM(Table1[Val]), FILTER(ALL(Table1),Table1[Val]

[@AnalyticswithNags]

Use the formula explained in the video

[@jim_19]

Have you made a video like you mentioned on how to display a running total based on 'total sales' measure?

[@AnalyticswithNags]

Running total based on any measure is same

[@jim_19]

@@AnalyticswithNags based on the measure's rank

[@sumitbansal7962]

Hi Nag i saw your above video but the running total measure is not showing correct values can you please help me out

[@AnalyticswithNags]

Not sure about your issue can’t help much on this

[@mattiamaetini]

Very helpful video! I add one extra tip: after first column I have a rank (produced by order by Total Sales desc): my goal is to produce a running total following this order by rank. Could you help me with this extra request into your formula? BR, M

[@karthickudt9]

when i clear all filter, power BI got hanged for long time and shows huge data size error. my data size is less than 5 lakes rows. any suggestions..

[@AnalyticswithNags]

Increase your system RAM. My recommendation is 8gb RAM. If you fine with 16gb go for it , then you will not face any issues

[@vykuntaraotangudu7420]

As you said not working when you put asc in the calculation It not works even when yo made the first column descendeing and cumulative totals showing wrong way with desc in the calculation ( It should show cumulative from top to bottom irrespective how you ordered the first column)

[@AnalyticswithNags]

Thanks for your feedback

[@adnanshaikh2403]

Nicely explained! I was tring to find the second part of video where we want cumulative total based on total sales sorting, can someone help

[@surender665]

Hi, please help me how to write dax, I want to running total exclude current month.

[@AnalyticswithNags]

Calculate running total uncheck the current month

[@surender665]

@@AnalyticswithNags Sir i want dynamic

[@vatsalabhatt9144]

Very helpful, thanks

[@PranavS01]

Thanks..

[@AnalyticswithNags]

welcome

[@jagannathprasadjena5829]

wow so nice

[@AnalyticswithNags]

Many many thanks

[@balaroxx2700]

Same doubt

[@superlhily09]

I tried this syntax but my result in grand total is infinity.

[@AnalyticswithNags]

Not sure

[@irfandaud7380]

T NonDate RT1 = CALCULATE(DATA[T Total Sale], FILTER(All(DATA[Product name]), DATA[Product name]

[@samkaran6351]

What is the yse of max product nane