Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Closest value large then sales for each SKU

    Posted 11 days ago

    Hi,

    I'm looking into our storing capacity and the excess inventory, and would like to have your help with a DAX-formula.

    The following table is the dataset where each row is one pallet. The column named Comment is my goal to achieve.


    Example, product ABC:

    The sales for ABC during the past four months are 10 peices. 10 peices do we have to cover in stock, so for ABC we need the first two pallets. The other two pallets are excess inventory.




    /Patrik



    ------------------------------
    Patrik Forssander
    Logistics Analyst
    ------------------------------


  • 2.  RE: Closest value large then sales for each SKU

    Top Contributor
    Posted 9 days ago
    Hi,

    Try to add a column with this formula

    Comment = 
    VAR _CurrPRoduct = CALCULATE( MIN('Table'[Row]), ALLEXCEPT('Table','Table'[Product]),'Table'[Running_Qty]>'Table'[Sales 4 months])
    
    RETURN
    IF(
        _CurrPRoduct && 'Table'[Row]> _CurrPRoduct, "Excess inventory", "ok")   ​
    Should be ok, tell us...

    I hope this helps

    ------------------------------
    Nicolas MENDEZ
    Data & BI consultant
    Becom Consulting
    ------------------------------



  • 3.  RE: Closest value large then sales for each SKU

    Posted 7 days ago

    Hi,

    Thank's for the help. It's working perfect

    BR



    ------------------------------
    Patrik Forssander
    Analyst
    ------------------------------