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

  • CalebSalo's avatar
    CalebSalo
    Regular Visitor
    3 years ago

    Hi amitchandak thank you for your response. 

     

    I've created the measure as instructed but I don't think the output table was correct. I believe the computer 1/1/2023, car 3/1/2023, and computer 2/1/2023 should have missing PNs listed in the column. I've attached a screenshot of my visuals page. 

     

    I should also note that sometimes there are items that appear in the orders table for a particular product that are not on the BOM. These items can be ignored and visibility of them is not necessary. Not sure if this affects the proposed solution but thought I would mention it.