undefined

[enrsshar]

Hi everyone,

I’m working with two queries in Power BI:

1. Completed MOs (Manufacturing Orders): This query gives me a list of completed manufacturing orders.
2. Tooling Data: This query provides data related to tooling, which includes Manufacturing Order Numbers (MOs).

I’ve created a table combining both queries, but when I view the data, I can still see tooling values for non-completed MOs, even though I only want to display the values for completed MOs.

There is no specific "status" column in the Tooling Data query that shows whether an MO is completed or not. However, both queries contain the Manufacturing Order Number column, so I was hoping to filter the tooling data based on whether the MO exists in the Completed MOs list.

How can I filter the tooling data so that only the completed MOs are shown in the table, and the non-completed MOs are excluded?

Thanks in advance for your help!

[Chew_WenJie · Accepted solution]

• Solution 1: Instead of combining the two queries, you can link them using relationships. It should be a one-to-many relationship, where you select the MO number from the CompletedMO table and retrieve the details from the other table.

• Solution 2: If you choose to merge the two queries, it should display only the completed MO numbers. The steps are:

  • Merge the queries based on MO numbers from both tables.
  • 
  • Expand the merged table.
  • 
    
  • This will ensure that only completed MO numbers and their corresponding details are shown.
  • 

Hope it helps. 😁