Concatenate multiple values into new column.

[Dudditz]

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

[amitchandak · Accepted solution]

@Dudditz , I discussed three method in this video

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

[Dudditz]

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