Forum Discussion

gianmarco's avatar
gianmarco
Helper IV
2 years ago
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 ...
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

gianmarco's avatar
gianmarco
Helper IV
2 years ago

Dear Ahmedx , I hope i didn't have to use merge queries each for every column. This is a sample dataset but actually my fact table consists of 30 columns. I thought there could be a more effective solution.