How to filter distinct values using M or DAX looking just 1 column?

Question

I have the following table:CodeProductPrice1Banana121Apple532Watermelon633Grape684Bread344Rice535Beans25&nbsp;I need to filter just the distinct and 1 from that repets, like the following table:CodeProductPrice1Banana122Watermelon633Grape684Bread345Beans25&nbsp;Apple and Rice was gone in the last table, in other words, filtered the distinct "Codes".I tried DISTINCT on DAX but it works for all columns, I need to focus the DISTINCT in just 1 column.

hotchilli · Accepted Answer

In Power Query editor, right-click the column, choose 'remove duplicates'

Forum Discussion

How to filter distinct values using M or DAX looking just 1 column?

2 Replies

Related content

Distinctive Count across two columns

count distinct

Count distinct values in one column, grouped by another column

distinct count of multiple columns

Getting distinct values for multiple columns

Code	Product	Price
1	Banana	12
1	Apple	53
2	Watermelon	63
3	Grape	68
4	Bread	34
4	Rice	53
5	Beans	25