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'[...
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

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