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.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, steff131284 

If it is OK with you, please share your sample pbix file's link here, then I can try to look into it to come up with an accurate solution.

Thanks.

steff131284's avatar
steff131284
Frequent Visitor
5 years ago

How can I share it, file type pbix is not supported?

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, steff131284 

    Please save your file in Onedrive or googledrive, and you can share the link here.

    Thank you.

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi, steff131284 

        Thank you for sharing.

        I am not quite sure if I understood your question correctly. I just calculated the next month's sales. Then, created the final measure. Those are the belows.

        Please check the link down below as well.

         

        Sales Next Month =
        VAR nextmonthstartdate =
        EOMONTH ( MAX ( DateTable[Date] ), 0 ) + 1
        VAR nextmonthenddate =
        EOMONTH ( MAX ( DateTable[Date] ), 1 )
        VAR nextmonthsales =
        CALCULATE (
        [Sales],
        FILTER (
        ALL ( DateTable ),
        DateTable[Date] >= nextmonthstartdate
        && DateTable[Date] <= nextmonthenddate
        )
        )
        RETURN
        nextmonthsales
         
         
         
        Days inventory V2 = DIVIDE([Ending inventory],[Sales Next Month])*30