Inventory Update each request attribuiting status

[Pedro_Gomes]

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:

[amitchandak]

@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")