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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Santhosh_V
Regular Visitor

Need to concatenate String values based on User Email Address

Hi All,

 

I have a License report where each user and it will hold multiple lines of entries with respect to their assigned licenses. I would like to combine the User license details for each user and put them on a cell separated by Comma. Also, it will have duplicate license name for each user, We need to pick the unique licenses and need to concatenate them with comma. Below is a sample exported report and the Required output format.

Santhosh_V_0-1679428074213.png

 

Looking for some help on this. Thanks in Advance!!

 

1 ACCEPTED SOLUTION
Padycosmos
Solution Sage
Solution Sage

4 REPLIES 4
Padycosmos
Solution Sage
Solution Sage

In the column containing the original data, you can right click and remove duplicates as shown below and then combine rows:

Padycosmos_0-1679498796590.png

 

Padycosmos
Solution Sage
Solution Sage

Santhosh_V
Regular Visitor

@v-yueyunzh-msft , @FreemanZ @Padycosmos , Any help on this?

 

Thank you!

@Padycosmos,

 

Yes, It combines values but it keeps duplicated values within the licenses column.

Santhosh_V_0-1679463848740.png

Could you please help on this?

Thank you.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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