Forum Discussion

Abhaykumar's avatar
Abhaykumar
Microsoft Employee
10 years ago
Solved

Getting distinct values for multiple columns

Is there a way to get distinct values for multiple columns? Specifically, I want to replicate the following SQL query into PowerBI to create a new table:   SELECT DISTINCT Col1, Col2, Col3 FROM Tab...
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Abhaykumar You can also select individual columns in query editor and click Remove Duplicates.

     

  • achinm45's avatar
    achinm45
    10 years ago

    Hi Abhaykumar,

     

    Use DAX and in DAX the function SUMMARIZE().

    Summarize will pull out distinct values from columns.

     

    So your resultset will be new table from Summarize

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

     

    I hope it helps !

     

    BR,

    Achin

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Abhaykumar You can also select individual columns in query editor and click Remove Duplicates.

 

  • ImkeF's avatar
    ImkeF
    Community Champion
    10 years ago

    My anser was rubbish (it would create a list of distinct values of the selected columns and returns it as a list if applied as a standalone-command (and not within a Table.AddColumn-command where will be performed as a function acting on record-level)).

     

    Do as ankitpatira said in the query-editor: First select the columns with your mouse and then click as shown. No need to edit a formula then :-)

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    ankitpatira if he reomves the duplicates will it not remove the entire row ? which will ultimately result in wrong data ?

    i am new to powerBI