Forum Discussion
Pivot - Several databases - Many to Many
Hi,
In order to make your datamodel work properly, you ideally create a Customer Dimension.
This is a list with all unique Customers and optional more information on them.When you created this, you can simply connect both as you call it "databases" to the same table with a 1 to many connection(always try to stay from many to many)
How to create this?
Idealy, just go to PowerQuery --> Right click on a table that contains all Customers --> Reference --> Remove all columns except customer(key) --> Remove duplicate values of Customers
Now you have a list of all unique customers, this you can connect to all other tables containing multiple customer rows.
Hi,
In order to make your datamodel work properly, you ideally create a Customer Dimension.
This is a list with all unique Customers and optional more information on them.
When you created this, you can simply connect both as you call it "databases" to the same table with a 1 to many connection(always try to stay from many to many)
How to create this?
Idealy, just go to PowerQuery --> Right click on a table that contains all Customers --> Reference --> Remove all columns except customer(key) --> Remove duplicate values of Customers
Now you have a list of all unique customers, this you can connect to all other tables containing multiple customer rows.
Hello RobbeVL,
You was right, stay far from many to many. Now it works perfctly.
Many thanks all of you,