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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Dudditz
Regular Visitor

Concatenate multiple values into new column.

Hello, I am looking for some assistance to Concatenate multiple fields into a new column.  These values have a common GUID from dataverse.

 

So the goal would be to createa  new column that would Concatenate the all related values based upon the GUID in a new colum.

 

Example the highlighted related GUID would display the following values in the new column so basically the values seperate by a space and ,

 

I have been struggling with this one so any help would be appreciated.

 

Truck #389, CoreDrill1

Dudditz_1-1660747891662.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Dudditz , I discussed three method in this video

 

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Dudditz , I discussed three method in this video

 

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

Hi  Amitchandak,  Option 3 was exactly what we needed.  Thank you so much for you help.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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