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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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