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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Quenril
Resolver I
Resolver I

Remove duplicate text values across multiple columns

Hello!

 

New Power BI user here and struggling a bit with cleaning my data... I suspect this may be an easy one for you all, so please help if you can..?

 

I have attached a screenshot of my data table (each letter represents a Consultant name). I need to de-duplicate the names in the table so that the name in the Lead Consultant column doesn't recur in Attendee columns 1-3.  

Current datasetCurrent dataset

 

So my ideal solution would look like this:

Dataset solutionDataset solution

 Thank you so much!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@QuenrilYou can go into the Query Editor and create 3 new Consultant Attendees conditional columns. I've shown one below as an example. Once all the new Consultant Attendees columns have been created, you can remove the 3 original ones and rename the new ones to what they should be.

bchager6_0-1703875390080.png

 

bchager6_1-1703875428541.png

 

Final result:

bchager6_2-1703875503310.png

 

View solution in original post

5 REPLIES 5
Quenril
Resolver I
Resolver I

@Anonymous and @PijushRoy thank you both so much. I did consider conditinoal columns but it felt like I was simply duplicating data so I thought I must be missing something. Thank you for confirming that this is the best approach 😁

Thanks @Quenril 
After posting, saw @Anonymous already posted the same solution.

Pijush




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Anonymous
Not applicable

@Quenril  You're welcome

PijushRoy
Super User
Super User

Hi @Quenril 

Please create  conditional column, then delete  original column

PijushRoy_0-1703875637539.png

 

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Anonymous
Not applicable

@QuenrilYou can go into the Query Editor and create 3 new Consultant Attendees conditional columns. I've shown one below as an example. Once all the new Consultant Attendees columns have been created, you can remove the 3 original ones and rename the new ones to what they should be.

bchager6_0-1703875390080.png

 

bchager6_1-1703875428541.png

 

Final result:

bchager6_2-1703875503310.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.