Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Remove Duplication

Hi,

 

looking for a function, in excel, Remove Duplicates in Power Bi.!

 

 

 

 

 

Thanks,

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago
    Hi, In the Query Editor, select all columns that you want to search duplicates in, right click and select Remove Duplicates.
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

     

    Kindly mark the helpful answer as a solution if you feel that makes sense.You may also find it under 'Remove Rows' in query editor.

    Regards,

    Cherie

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago
    Hi, In the Query Editor, select all columns that you want to search duplicates in, right click and select Remove Duplicates.
  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous 

     

    Kindly mark the helpful answer as a solution if you feel that makes sense.You may also find it under 'Remove Rows' in query editor.

    Regards,

    Cherie