Forum Discussion
Remove duplicates from multiple columns BUT keep the blank and null values.
I have a 3 columns of serial numbers, IMEI numbers and phone numbers. I want to remove the duplicates from each column BUT keep the BLANK and NULL cells. Is there a measure to remove the duplicates in all 3 columns BUT keep the NULL and BLANK rows and how do I implement this measure ? The columns are named IMEI, Serial Number and Phone Number.
Hi Anonymous
You can click Modeling > New table and enter the code into the formula bar. This will create a new table based on the original table.
Or you can click Transform data to open Power Query Editor and try Remove Duplicates under Remove Rows.
If this doesn't work, please provide some sample data and expected result.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
4 Replies
- selimovd
Most Valuable Professional
Hey Anonymous ,
in general you can do that with the SUMMARIZE function.
The SUMMARIZE function will also keep BLANK and empty values.
An approach would be:
SUMMARIZE( myTable, myTable[IMEI], myTable[Serial Number], myTable[Phone Number])If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
v-jingzhangCommunity Support
Hi Anonymous
You can click Modeling > New table and enter the code into the formula bar. This will create a new table based on the original table.
Or you can click Transform data to open Power Query Editor and try Remove Duplicates under Remove Rows.
If this doesn't work, please provide some sample data and expected result.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
