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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Quenril
Regular Visitor

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
bchager6
Super User
Super User

@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
Regular Visitor

@bchager6 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 @bchager6 already posted the same solution.

Pijush

@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

bchager6
Super User
Super User

@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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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