remove duplicates over 2 column dax

Anonymous — Wed, 17 Jan 2024 14:59:01 GMT

I need to create a Dim table based on fact, and I need to avoid to use power query.

What i'm trying to get it's a DAX that allows me to select some columns from a table, and gives me back just the unique value.
Something you can easilly do by selecting the two column and type "remove duplicates" in power query.

Doing it in DAX would let me have a lighter file
Here an example
From

A	B	C
Red	2	big
Red	2	Small
Jellow	1	Big

I need to obtain
AB

A	B
Red	2
Jellow	1

Re: remove duplicates over 2 column dax

barritown — Wed, 17 Jan 2024 15:11:46 GMT

Hi Anonymous,

This line should help you to achieve the required outcome:

New Table = SUMMARIZE ( 'Table', 'Table'[A], 'Table'[B] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

topic Re: remove duplicates over 2 column dax in DAX Commands and Tips

remove duplicates over 2 column dax

Re: remove duplicates over 2 column dax