Forum Discussion
Sawtooth decay charts in Power BI
Hello!, I am trying to create a cyclic graph in Power BI with a condition added upon it. I have the following data structure. Day Starting Amount Safety Stock Units per Day Lot Size On...
lbendlin
Super User
Super UserYou cannot create semi additive columns in Power BI. The only way to do this is in Power Query with List.Accumulate.
How many days in advance do you need to calculate?
What do you do with the chart once it is computed?
The safety stock numbers are generated in dax itself. So my current requirement involves the use of DAX based solutions. But if it cannot be done then I will find some alternative.
My plan was to create a chart that tracks the on hand inventory value by each day