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

  Рет қаралды 11,987

BI Tech Lake

BI Tech Lake

Күн бұрын

Пікірлер: 20
@PradeepKumar-mh5ht
@PradeepKumar-mh5ht Жыл бұрын
Thanks a lot for sharing this kind of video and explaining so well.
@KuldeepSingh-nq1vi
@KuldeepSingh-nq1vi 5 ай бұрын
Wow Great Video Sir.
@Giridharan952
@Giridharan952 11 ай бұрын
Nice Point in learning path......
@Abbaskhan-re9ck
@Abbaskhan-re9ck 10 ай бұрын
Searching a simple solution for long time for this problem, today got it... thankssssss
@Ratnakumarwrites
@Ratnakumarwrites Жыл бұрын
Simple and nice solution bro...
@BITechLake
@BITechLake Жыл бұрын
Yes, thanks
@shivanisinghal9992
@shivanisinghal9992 8 ай бұрын
Thanks a lot!! 👍
@manojkahar5718
@manojkahar5718 Жыл бұрын
Great vedio sir
@micha_SVB_FD
@micha_SVB_FD 6 ай бұрын
amazing❗
@glenndissinger4587
@glenndissinger4587 3 ай бұрын
Fantastic, thanks.! Avoid the the mistake I made, and be sure to Create the duplicate Query (Sales Data (2)in this example) before creating the index columns and list. If you don't, and make the copy during the 2nd part of the video, you'll end up getting INDEX already exists errors after you Invoke the Function in the 2 part of this video.
@hvaquiro
@hvaquiro 9 ай бұрын
Thanks so much
@manuc5353
@manuc5353 8 ай бұрын
Thank You!
@ruunaljagtap3293
@ruunaljagtap3293 Жыл бұрын
Thank you
@BITechLake
@BITechLake Жыл бұрын
You're welcome
@dinohadjiyannis3225
@dinohadjiyannis3225 6 ай бұрын
brilliant
@ektamaurya4466
@ektamaurya4466 Жыл бұрын
Can we also add ranking to this in order to get top 50% for example?
@BITechLake
@BITechLake Жыл бұрын
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.
@SoOS186
@SoOS186 5 ай бұрын
How can i do running total of distinct counting of rows. From multiple data sources? From a folder source, i have 3 excel files with same information but data is updated and rows are increasing gradually in each file. How to know the amount of increased data in each file?
@PradeepKumar-mh5ht
@PradeepKumar-mh5ht Жыл бұрын
Thanks a lot for sharing this kind of video and explaining so well.
@BITechLake
@BITechLake Жыл бұрын
Glad it was helpful!
Fast Running Totals in Power Query (Complete Guide)
29:16
BI Gorilla
Рет қаралды 33 М.
Every team from the Bracket Buster! Who ya got? 😏
0:53
FailArmy Shorts
Рет қаралды 13 МЛН
Running Total in Power BI (for Date and Non Date Values)
9:05
Using the List technique in Power Query to recombine tables
6:51
Access Analytic
Рет қаралды 6 М.
How to Calculate Cumulative Total with DAX in Power BI
6:44
Essential Excel
Рет қаралды 68 М.
Power Query Running Totals - The Right Way!
11:53
MyOnlineTrainingHub
Рет қаралды 79 М.
How to Move Data Automatically Between Excel Files
11:37
Kenji Explains
Рет қаралды 273 М.
The Excel Tool That Does What PivotTables Can’t (File Included)
13:59
MyOnlineTrainingHub
Рет қаралды 283 М.
Create a Running Total by Category in Power Query
17:44
BI Gorilla
Рет қаралды 34 М.