Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    You 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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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