Forum Discussion
Solved
Running Total for 100 columns
Hello community! I am trying to calculate a running total in the Power Query Editor for 100 columns and I am looking for a simpler solution than manually inserting a new column 100 times. I have ...
I have calculated the running total now after unpivoting with the help of here:
https://www.youtube.com/watch?v=EFQBMJ6JyCQ&t=313s
jdbuchanan71
Super User
Super UserYou should unpivot all of your material columns so you end up with 3 total columns.
Date / Material / Demand
Then you would join that to a date table in your model and add a running total measure.