Sawtooth decay charts in Power BI

Question

Hello!,&nbsp;I am trying to create a cyclic graph in Power BI with a condition added upon it.&nbsp;I have the following data structure.&nbsp;DayStarting Amount&nbsp;Safety StockUnits per DayLot SizeOn Hand Inventory0800550302008001800550302007702800550302007403800550302007104800550302006805800550302006506800550302006207800550302005908800550302005609800550302007301080055030200700The objective is to generate a decay curve with saw tooth like features. The starting on hand stock (800 units) decays at the rate of 30 units per day. The day on which it goes below the safety stock value, lot size number of units are added back to the system again. This cycle continues. The objective is to create a column like the last column (on hand inventory) which tracks these movements and shows the current on hand inventory at any given time.&nbsp;The final graph created would look something like this. (The dotted lines should indicate the safety stock level in my case).&nbsp;&nbsp;

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

anonymous · Answer

Edited the post as per your suggestion. Would be helpful if you have any leads for the solution

lbendlin · Answer

You cannot create semi additive columns in Power BI.&nbsp; The only way to do this is in Power Query with List.Accumulate.
&nbsp;
How many days in advance do you need to calculate?
What do you do with the chart once it is computed?

anonymous · Answer

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.&nbsp;My plan was to create a chart that tracks the on hand inventory value by each day&nbsp;

Forum Discussion

Sawtooth decay charts in Power BI

4 Replies

Related content

Line chart

Comparison Chart

Sankey Chart

chart suggestion

Run Charts/p-charts in Power BI?

Day	Starting Amount	Safety Stock	Units per Day	Lot Size	On Hand Inventory
0	800	550	30	200	800
1	800	550	30	200	770
2	800	550	30	200	740
3	800	550	30	200	710
4	800	550	30	200	680
5	800	550	30	200	650
6	800	550	30	200	620
7	800	550	30	200	590
8	800	550	30	200	560
9	800	550	30	200	730
10	800	550	30	200	700