I want to remove duplicate data from table
Go to Solution.
@RajSaha20 , 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.
Proud to be a Super User!
View solution in original post
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)
DAX DISTINCT (table)
You can remove duplicates in power query.
Appreciate your kudos!! Mark this post as solution if this helps.
Not clear but if you wanna remove duplicate Rows, Use Remove Rows > Remove Duplicates on Power Query.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.