power bi union two columns code example Example: power bi union columns NewTable = UNION(DISTINCT(Table1[Email]), DISTINCT(Table2[Email])