Forum Discussion

steff131284's avatar
steff131284
Frequent Visitor
5 years ago
Solved

Simple inventory development

Hi, I am totally new to Power BI and have a simple question to show inventory forecast   I have:   Starting inventory by sku --> Bestand = SUM(Bestand[Bestand heute])   Inventory Increase by...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, steff131284 

     

    Please try the below.

     

    Forecast =
    CALCULATE (
    [Bestand],
    FILTER ( ALLSELECTED ( DateTable ), DateTable[Date] <= MAX ( DateTable[Date] ) )
    )
    + CALCULATE (
    [Delta],
    FILTER ( ALLSELECTED ( DateTable ), DateTable[Date] <= MAX ( DateTable[Date] ) )
    )

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

steff131284's avatar
steff131284
Frequent Visitor
5 years ago

This is perfect, although I have no idea what this formula does 🙂
Last thing. What do I need to do, that also my startig inventory is shown for all months?


  • steff131284's avatar
    steff131284
    Frequent Visitor
    5 years ago

    Thank you so much