Forum Discussion

Rapture101's avatar
Rapture101
New Member
4 years ago
Solved

Separating Values by comma

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!

 

                                                                       

6 Replies