Forum Discussion
How to remove the duplicate data from table
I want to remove duplicate data from table
Anonymous , not very clear. You can use remove duplicate from power query
Refer if my video can help https://www.youtube.com/watch?v=Hc5bIXkpGVE
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.Hi Anonymous,
You can use the 'remove duplicate' function to remove these records on query editor side or try to create a calculated table with 'distinct' function to remove duplicate records.
Remove duplicates (Power Query)
Regards,
Xiaoxin Sheng
4 Replies
Anonymous ,
Not clear but if you wanna remove duplicate Rows, Use Remove Rows > Remove Duplicates on Power Query.
Regards,
Manikumar
Anonymous , not very clear. You can use remove duplicate from power query
Refer if my video can help https://www.youtube.com/watch?v=Hc5bIXkpGVE
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.Hi Anonymous,
You can use the 'remove duplicate' function to remove these records on query editor side or try to create a calculated table with 'distinct' function to remove duplicate records.
Remove duplicates (Power Query)
Regards,
Xiaoxin Sheng
