Forum Discussion

CalebSalo's avatar
CalebSalo
Regular Visitor
3 years ago

Compare Two Lists and Return Missing Items

I have 2 tables. The first table is a bill of materials (BOM) that has 3 columns: 1) the product being built 2) which part number (PN) is needed 3) the inventory status of the PN (whether we need...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

CalebSalo , Plot  this measure along with product and release date from orders table

 

mising product =
var _tab = except(Summarize(filter(BOM, BOM[Product]= max(Orders[Product])),BOM[Product]), distinct(Orders[Product]))
return
if(isblank(countx(_tab,[Product])), "Fully Ordered", concatenateX(_tab, [Product], ", "))

 

another approch

Power BI Items/Categories not sold to the customers
Power BI Items/Categories not sold to the customers: https://youtu.be/AbuKvAnicwo