Running Total In Power Query | Running Sum In Power Query

Running Total In Power Query | Running Sum In Power Query | Cumulative sum in power query

Рет қаралды 6,886

10 ай бұрын

In this video we will see how to calculate running total using power query. Many times we need to calculate cumulative sum of amount to understand till data value. Power query makes it easy to calculate cumulative sum.
This video solves below queries.
======================================================
1. Calculate running total in power query.
2. Calculate cumulative sum in power query.
3. Calculate running total by group using power query
4. Power query to calculate running sum.
======================================================
Also take a look at more videos
1. Delete error rows in excel.
Link - • Remove Error Rows In E...
2. How to implement excel like trim in power query.
Link - • Trim Like Excel In Pow...
======================================================
Contact us at - BizzIntelligence.Tech@gmail.com
#bitechlake #bizzintelligence #powerquery

Пікірлер: 15

@PradeepKumar-mh5ht 9 ай бұрын

Thanks a lot for sharing this kind of video and explaining so well.

@Abbaskhan-re9ck 3 ай бұрын

Searching a simple solution for long time for this problem, today got it... thankssssss

@Giridharan952 4 ай бұрын

Nice Point in learning path......

@manojkahar5718 10 ай бұрын

Great vedio sir

@shivanisinghal9992 Ай бұрын

Thanks a lot!! 👍

@manuc5353 Ай бұрын

Thank You!

@Ratnakumarwrites 8 ай бұрын

Simple and nice solution bro...

@BITechLake 8 ай бұрын

Yes, thanks

@hvaquiro 2 ай бұрын

Thanks so much

@ruunaljagtap3293 9 ай бұрын

Thank you

@BITechLake 9 ай бұрын

You're welcome

@ektamaurya4466 9 ай бұрын

Can we also add ranking to this in order to get top 50% for example?

@BITechLake 9 ай бұрын

Yes we can. To keep it simple you can sort the data by running total field in descending order and add an index column which will be the rank. If you have to rank the values then it's easy using DAX calculation.

@PradeepKumar-mh5ht 9 ай бұрын

Thanks a lot for sharing this kind of video and explaining so well.

@BITechLake 9 ай бұрын

Glad it was helpful!