Separating Values by comma

[Rapture101]

Hello All!

I seem to be getting stumped and cannot find an article or video about sepearating duplicate values

Orginal table:

Owned by | Business service | Description | User Type | User

IT              |  AVS                    |     Used by IT   | Affected user |  Mandy, bobbill

IT              |  AVS                    |     Used by IT   | Owner |  Mandy, bill

IT              |  AVS                    |     Used by IT   | Business Owner |  Mandy, bob

IT              |  AVS                    |     Used by IT   | Affected user |  Bill, Bob

IT              |  AVS                    |     Used by IT   | Affected user |  Bob, Bill

The above is the table listing a few duplicate values

I then pivot the table try max or don't aggregate ect, but then my table shaves off the other users ex:

Owned by | Business service | Description | Affected user | Owner | Business Owner

IT              |  AVS                    |     Used by IT   | Mandy, bobbill | Mandy, bill |  Mandy, bob

Expected result that I am trying to accomplish:

Owned by | Business service | Description | Affected user | Owner | Business Owner

IT              |  AVS                    |     Used by IT   | Mandy, bobbill, Bill, Bob, Bob, Bill | Mandy, bill |  Mandy, bob

What I tried: I tried keep duplicates, I tried different pivot methods, I tried grouping but none seem to give me the ability to put a comma in between names of people and keep the data.

My question: Is this possible in power bi? I know I can perform this in ssrs: report builder. 

Thank you and please let me know if I can provide more data or info!

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Rapture101]

Hi! Unfortunately, I cannot download the sample file.

[Ashish_Mathur]

Hi,

It is available below my signature.

[ryan_mayu · Accepted solution]

@Rapture101 

you can do this in PQ. pls see the attachment below.

[Rapture101]

This did it! Thank you!

[ryan_mayu]

you are welcome