CODEWITHSUNDEEP
datatablespowerbiuniqueselectionlookup
Dreqnoid
Dreqnoid

Reputation: 31

Combine data of two columns in power bi and combine set for new table

I have two tables:

Table #1 - recipe:

enter image description here

Table #2 - cakes:

enter image description here

What I want in PowerBI is:

  1. select material (done)
  2. show table with all the recipes versions
  3. show another table with all the cakes baked based on recipe (and previous versions)

So far so good, I've create a custom table with material, cakematerial and recipematerial.

enter image description here

Now I also would like to have another report/table showing orders with the same lot and order-prefix.

For example: Ordernr 2000-010 and ordernr 2000-020 have the same LOT (lt011c). I want these to be shown in one table and then another table with the recipes (and history) belonging to both orders.

So in this case: Recipenr L10-BACK01 and L11-BACK01 with complete version history.

Is that possible?

Datamodel in Power BI:

Datamodel

Upvotes: 0

Views: 438

Answers (1)

Mark Wojciechowicz
Mark Wojciechowicz

Reputation: 4477

The answer was to change the relationships to both directions between the 3 tables. This would allow you to filter from any table related to Material

Upvotes: 1

Related Questions