Forum Discussion

Pedro_Gomes's avatar
Pedro_Gomes
New Member
3 years ago

Inventory Update each request attribuiting status

Hello,

On Power BI I have a Inventory that have a lot of requests of the same Item and the same Date. For this reason I need to make an status telling me if that inventory will be anough or not for those requests

For Now I just have the first Part:

Inventory
Inventory Allocation
Inventory Deduction

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Pedro_Gomes , If you need a new column

    new column =

    var _sum = sumx(filter(Table, Table[item] = earlier([item]) && [Date] <= earlier([date])  ), [Inventory]+0 - [quantity])

    return

    if(_sum<= 0 , "No Inventory", "OK Inventory")

     

    or

     

    new column =

    var _sum = sumx(filter(Table, Table[item] = earlier([item]) && [Date] <= earlier([date]) && Table[product] = earlier([product])   ), [Inventory]+0 - [quantity])

    return

    if(_sum<= 0 , "No Inventory", "OK Inventory")