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
Anonymous
Not applicable

Form relationships between two columns from two tables

I have one table with a unique reference i.e. 'SPP009(b)', and I have another table with a unique reference i.e. 'SPP009(b) - text'.

The second table has text after the unique reference number within the column.

How do I make a relationship between these two columns if one has only the reference and the other has the reference and description?

 

milo1234_0-1623842778487.png

 

milo1234_1-1623842791083.png

 

 

 

1 ACCEPTED SOLUTION
Singaravelu_R
Resolver III
Resolver III

Duplicate the same text column as per screenshot in query editor,

 

Singaravelu_R_0-1623843802969.png

and Transform split column 

 

Singaravelu_R_1-1623843913484.png

 

and close and apply the query editor follow the steps as per screenshot,

 

Singaravelu_R_2-1623844091752.pngSingaravelu_R_3-1623844113203.png

 

View solution in original post

1 REPLY 1
Singaravelu_R
Resolver III
Resolver III

Duplicate the same text column as per screenshot in query editor,

 

Singaravelu_R_0-1623843802969.png

and Transform split column 

 

Singaravelu_R_1-1623843913484.png

 

and close and apply the query editor follow the steps as per screenshot,

 

Singaravelu_R_2-1623844091752.pngSingaravelu_R_3-1623844113203.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.