Forum Discussion

Rolf's avatar
Rolf
Frequent Visitor
8 years ago
Solved

Remove duplicates based on values from multiple cells

Hey,   I am trying to append few datasets. The problem with my data is that there may be completely identical rows in there which i want to remove. At the end i only want to keep the truly unique r...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Rolf,

     

    Hi Rolf.

     

    It's easy to do it in the Query Editor.

    1. Select the columns "ID", "lat", "longit", "Time" at the same time with "Ctrl".

    2. Use the function as Anonymous suggested.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

waeltken's avatar
waeltken
Helper I
5 years ago

Hey All,

 

Is there a comparable approach to accomplish the multi-column deduplicate in a table filter function in DAX?

 

Regards,

 

 

Henrik