How can you create columns of distinct values in Power BI

DAX DAX Calculations
1

Hello,

I’m trying to do this SQL query into Power BI to create a new table:
SELECT DISTINCT Col1, Col2, Col3 FROM TableA;

I’m looking for a way to get distinct values for multiple columns.
Any suggestion is welcome.
Thanks in advance!

2

A good understanding of the SUMMARIZE function will get you where you want to be here.

You can use the DAX function SUMMARIZE(), just like below:

Table_Output = Summarize(Table_IN,Col1,Col2,Col3)

Or you can select individual columns in the Query Editor and click “Remove Duplicates”.

See below for more ideas.

http://portal.enterprisedna.co/courses/mastering-dax-calculations/lectures/2000666

Also definitely check out the Advanced Transformations course at Enterprise DNA Online. Plenty of ideas bundled into this course for you which will help you think about this type of scenario more.

Sam