Forum Discussion
Removing duplicate values
Bpyne,
If you intend to remove duplicates, just right-click on the column in your table in Query Editor of Power BI Desktop, then select "Remove Duplicates". This way, each time you refresh the table in Power BI Desktop, you will always get unique values in the column.
Another method to identify duplicates is to use Power Query or DAX. For more details, please review the example in the similar blog and thread below.
https://www.excelguru.ca/blog/2015/12/09/identify-duplicates-using-power-query/
http://community.powerbi.com/t5/Desktop/Identify-duplicates-and-show-up-records/td-p/210061
Regards,
Lydia
Bpyne,
If you intend to remove duplicates, just right-click on the column in your table in Query Editor of Power BI Desktop, then select "Remove Duplicates". This way, each time you refresh the table in Power BI Desktop, you will always get unique values in the column.
Another method to identify duplicates is to use Power Query or DAX. For more details, please review the example in the similar blog and thread below.
https://www.excelguru.ca/blog/2015/12/09/identify-duplicates-using-power-query/
http://community.powerbi.com/t5/Desktop/Identify-duplicates-and-show-up-records/td-p/210061
Regards,
Lydia