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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Quenril
Helper I
Helper 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
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
Helper I
Helper I

@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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.