Video: Running totals in Power Query??? Yes, you can :)
Van: Ruth Pozuelo Martinez - Curbal AB
Duur: 5:05
Bereken de cumulatieve waarden van een kolom mbv. List.Range
In today's video, I am going to show you how you can do running totals or cummulative totals in Power Query, but do this only if you have no way to do it using DAX. Also, I will show you how List.Range work, really cool function :) Chapters: 00:00 Use case description 00:57 Show how List.Range works 02:00 Create an Index 02:40 Create the range 03:25 Transform a column to a list 05:10 Sum the values Done!
Functies: List.Range(), List.Sum(), List.Average()
