Forum Discussion
AdministratorRemove Duplicates Comparison in PowerBI vs Excel
Greetings to all. I have a slight problem and I don't know how to fix it. The issue is that when I perform "remove duplicates" in a table in excel I find a value of 5300 rows, but when I do it in powerbi they are only 5000. I do not understand what the difference is being that in both I perform the action "remove duplicates" in a particular column and I should give myself the same number of rows in both programs.
Syndicate_Admin , Please are you remove duplicates on a column or a table. Table.Distinct should not have any column name as an argument
When select a column by mistake in power query , it can to remove duplicate for a column
1 Reply
- amitchandak
Super User
Syndicate_Admin , Please are you remove duplicates on a column or a table. Table.Distinct should not have any column name as an argument
When select a column by mistake in power query , it can to remove duplicate for a column