It would be useful to have an M function to keep duplicates based on selected column(s). This would allow the users to see the user to recognise where the duplicates occur and to choose which row to keep in the Table (from the duplicates). At this moment to find the duplicates I am using GroupBy, Allrows, Count rows, Select the groups that has more than 2 in count. For large dataset that has over 500000 rows having few duplicates, this approach creates unwanted too many groups a Thus, this is not an efficient method I feel. A Table.NonDistinct function in M may help. Is that possible?
akatesmith
on:
Include field parameters functionality in Azure An...
on:
Get rid of Microsoft sidebar in Power BI new works...
on:
Improve Bookmark Pane Usability: Persistent Menus,...
on:
Case Sensitivity ragrdless of the connection type ...
frithjof_v
on:
Lakehouse SQL Analytics Endpoint snapshots
on:
Power Query - Feature addition - To keep duplicat...