Forum Discussion
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!
you can do this in PQ. pls see the attachment below.
6 Replies
- ryan_mayuSuper User
- Rapture101New Member
This did it! Thank you!
- ryan_mayuSuper User
you are welcome
- Ashish_MathurSuper User
- Rapture101New Member
Hi! Unfortunately, I cannot download the sample file.
- Ashish_MathurSuper User