Populate column with distinct values from another column in another table

[Anonymous]

Hi, as the title suggests I'm looking to populate a column in a new table with distinct values from a column in an existing table.

For example, Table1, Column1 = {1, 2, 2, 3, 4, 4, 5}

Should look like NewTable, NewColumn = {1, 2, 3, 4, 5}

[Greg_Deckler]

@Anonymous - Should be:

NewTable = DISTINCT(SELECTCOLUMNS('Table1',"NewColumn",[Column1]))

[theresad]

Hello! Are you able to adapt this formula to create a new column with unique values from two other columns? Say, 

NewTable = DISTINCT(SELECTCOLUMNS('Table1',"NewColumn",{[Column1],[Column2]})

Or something to that effect? 

[mahoneypat · Accepted solution]

Please try

Table2 = DISTINCT(Table1[Column1])

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

Where do I enter this code?

[Greg_Deckler]

@Anonymous -