Inventory Update each request attribuiting status

Pedro_Gomes — Fri, 28 Apr 2023 18:21:10 GMT

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:

Re: Inventory Update each request attribuiting status

amitchandak — Fri, 28 Apr 2023 21:15:47 GMT

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

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

topic Re: Inventory Update each request attribuiting status in DAX Commands and Tips

Inventory Update each request attribuiting status

Re: Inventory Update each request attribuiting status