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

[gluizqueiroz]

I have the following table:

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

I need to filter just the distinct and 1 from that repets, like the following table:

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

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 solution]

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

[HotChilli · Accepted solution]

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

[gluizqueiroz · Accepted solution]

Hey @HotChilli.

Man, that's so simple and I didn't know.

Thanks!