DAX Running Totals for Part Usage
This is an answer to a question from a training session today.
It shows how to create a column with running totals for usage for specific parts, by week number (with predicted usage of said part), so that we can report when we will be out of stock of each part.
I used a DAX solution because the real dataset is over a million rows, so needs to use the Data Model in Excel. The principles will be the same in Power BI.
You can assume also that slicers will be used on the final Pivot Table to filter it.