Forum Discussion

TomLU123's avatar
TomLU123
Helper III
8 years ago
Solved

Remove Duplicated Rows in a table

Hi Experts, 

 

I am creating a new table that collect all the dates of two other tables by using following formular.

Date Table =
UNION (
SELECTCOLUMNS('Overall Result',"Date",'Overall Result'[Date]),
SELECTCOLUMNS('Hiring Manager List',"Date",'Hiring Manager List'[Created]))

 

Is it possible to add some formular to remvoe duplicated date in this new table at the same time?

 

Many thanks!

 

Best regards,

Tom 

Need Help
  • donsvensen's avatar
    donsvensen
    8 years ago

    Hi Tom,

     

    You could use DISTINCT 

    DISTINCT(
    UNION (
    SELECTCOLUMNS('Overall Result',"Date",'Overall Result'[Date]),
    SELECTCOLUMNS('Hiring Manager List',"Date",'Hiring Manager List'[Created]))
    )

     

    or consider doing the table using Power Query

     

    /Erik

1 Reply

  • donsvensen's avatar
    donsvensen
    Skilled Sharer
    8 years ago

    Hi Tom,

     

    You could use DISTINCT 

    DISTINCT(
    UNION (
    SELECTCOLUMNS('Overall Result',"Date",'Overall Result'[Date]),
    SELECTCOLUMNS('Hiring Manager List',"Date",'Hiring Manager List'[Created]))
    )

     

    or consider doing the table using Power Query

     

    /Erik