Forum Discussion
Solved
undefined
Hi everyone, Iām working with two queries in Power BI: Completed MOs (Manufacturing Orders): This query gives me a list of completed manufacturing orders. Tooling Data: This query provides data r...
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. š
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. š