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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.