Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mb0307
Responsive Resident
Responsive Resident

Over/Under Stock

Hi all,

 

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

 

STOCK

Stock.jpg 

 

DEMAND

Demand.jpg

 

RESULT

result.jpg

 

How can i achieve this based on SKU please?

 

Thanks

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

 

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.