Forum Discussion
Solved
Table merging issue?
Dear All, I have two tables: FACT TABLE Item Colour Size Value 1 5 9 € 4.385 1 6 10 € 3.160 2 5 9 € 3.622 2 6 10 € 9.085 2 7 11 € 5.169 3 8 11 € 9.695 ...
pls try this
You can achieve it both ways. With relationships (that catalog table will have a 1 to many relationship to the fact table, using the ID column) or using Merge queries within Power Query.