Attaching Multi Data Tables

[Anonymous]

Greetings,

I have to use a scenario to explain due to confidentiality. I have a bakery and I am trying to connect production to the quality records by the following:

1. Connecting cleaning results by the tanks used by production to make the dough

2. Connecting quality records by the lot numbers used by production to identify the dough.

I have a master date table the sanitation, production, and quality records are tied to.

The report filters by date. Then the material number. I am able to get the material for that week and then click on the material number.

However when I filter this way I get all the quality records from that date instead of just the lot number.

And when I filter this way I get all the sanitation for that time, however, I need it to cover a 30-day spread because we may not wash it the same day its made. 

When I try to join say the production with the quality I get a relationship error.

When I try to join say the production with sanitation I get there is no relationship error as well.

Picture show relations as color coded ink.

[v-lionel-msft]

Hi @Anonymous ,

You don't need to show your real data, we just need to know which columns your tables have and the relationships between the tables.

Please give a sample data in the form of a table (preferably easy to copy).

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

posted sample

[Anonymous]

I posted an image.

[parry2k]

@Anonymous Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490