Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Team,
I have to remove duplicate based on single column.
see Keep column, don't keep B1, B3 and next item 02 also.
use Edit Query only.
Thanks,
KV's
Solved! Go to Solution.
HI @Anonymous ,
Can you kindly elaborate on your data please?
If I understand it correctly, you first need to split your column, then remove duplicates and merge them back.
Consider as follows:
Click on column and on top ribbon and make highlighted selection:
A new window appears. Fill in highlighted information:
You will get this:
Right click on 1st column and select Remove Duplicates:
You will get following:
Now merge these columns again by selecting both columns and right-click:
A window appears. Don't forget to mention the separator as in your original column values:
After merging you get the required result:
The values from your data are taken as example as you haven't shared the data in right format to be copied and pasted easily. I had to type the values. From next time make sure you add data in such a format that anyone can copy and use it in answering your query.
Try same steps on your data, you will get the desired result.
Thanks,
Pragati
Hi @Anonymous,
Please elaborate on your requirement.
HI @Anonymous ,
Can you kindly elaborate on your data please?
If I understand it correctly, you first need to split your column, then remove duplicates and merge them back.
Consider as follows:
Click on column and on top ribbon and make highlighted selection:
A new window appears. Fill in highlighted information:
You will get this:
Right click on 1st column and select Remove Duplicates:
You will get following:
Now merge these columns again by selecting both columns and right-click:
A window appears. Don't forget to mention the separator as in your original column values:
After merging you get the required result:
The values from your data are taken as example as you haven't shared the data in right format to be copied and pasted easily. I had to type the values. From next time make sure you add data in such a format that anyone can copy and use it in answering your query.
Try same steps on your data, you will get the desired result.
Thanks,
Pragati
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
83 | |
69 | |
68 | |
39 | |
37 |