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
FumaniMlambo
New Member

Field concatenation

Please help I am relatively new to the Power I platform. I have 2 tables, a Device table containing DeviceName, categoryID and other fields. I also have a Category table that contains CategoryName and Description. How can I go about joining the DeviceName values from the the Device table to the CategoryName and Description from the Category table to create a new merged table with the respevtive values. 

1 ACCEPTED SOLUTION
jbwtp
Memorable Member
Memorable Member

Hi @FumaniMlambo,

 

Are you asking how to merge tables? This is this button in the main menu:

jbwtp_0-1668458654750.png

In your case, I guess, this is merge on the Category ID column.

 

Cheers,

John

 

View solution in original post

1 REPLY 1
jbwtp
Memorable Member
Memorable Member

Hi @FumaniMlambo,

 

Are you asking how to merge tables? This is this button in the main menu:

jbwtp_0-1668458654750.png

In your case, I guess, this is merge on the Category ID column.

 

Cheers,

John

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors