Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
4 years ago
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?

 

Thanks

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

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

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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