Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gianmarco
Helper IV
Helper IV

Table merging issue?

Dear All,

I have two tables:

 

FACT TABLE

ItemColourSizeValue
159€ 4.385
1610€ 3.160
259€ 3.622
2610€ 9.085
2711€ 5.169
3811€ 9.695
469€ 6.620
4810€ 4.355

 

TEXT TABLE

IDValue
1Ring
2Bracelet
3Crown
4Necklace
5Yellow
6Green
7Blue
8Black
9Small
10Medium
11Large

 

 

My desired result is the following:

 

NEW FACT TABLE

ItemColourSizeValue
RingYellowSmall€ 4.385
RingGreenMedium€ 3.160
BraceletYellowSmall€ 3.622
BraceletGreenMedium€ 9.085
BraceletBlueLarge€ 5.169
CrownBlackLarge€ 9.695
NecklaceGreenSmall€ 6.620
NecklaceBlackMedium€ 4.355

 

I don't think I can manage this through relationships because it is admitted only one relationship between tables. Is merging of queries one for each column the only solution? 

 

Thank you

gianmarco

1 ACCEPTED SOLUTION

4 REPLIES 4
Ahmedx
Super User
Super User

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

Screenshot_4.png

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. 

pls try this

Screenshot_3.png

ray_aramburo
Super User
Super User

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.





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.