Over/Under Stock

[mb0307]

Hi all,

I want to analyse inventory using Demand and Stock data.  Please see table below:

STOCK

 

DEMAND

RESULT

How can i achieve this based on SKU please?

Thanks

[amitchandak · Accepted solution]

@mb0307 , You have to create a new table

SKU  =distinct(union(distinct(stock[SKU ]),distinct(demand[SKU])))

Join with both tables on SKU and use with both Table

Stock Over/Under  = Sum(stock[Stock]) - sum(demand[demand])

[mb0307]

Thank a lot @amitchandak