Forum Discussion
Solved
Over/Under Stock
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? Th...
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 , 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])
Thank a lot amitchandak