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 fo...
Inventory
Inventory Allocation
Inventory Deduction
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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")