Get distinct values of Multiple columns within the same table

[Anonymous]

Hi, Is there a way where I can combine distinct values of mutiple columns within the same table and display them in one single column.

For example I have Table A with columns X,Y,Z and all 3 columns have multiple values as shown below.

X        Y      Z

aa     ee    dd

bb    rrr    qq

ff      aa    rrr

The output of the DAX should be 

Outputcolumn

  aa

  bb

  ff

  ee

  rrr

  dd

  qq

Order of the values doesn't matter. 

Thanks for your time.

[amitchandak · Accepted solution]

@Anonymous , Try a new table like

distinct(union(all(Table[X]),all(Table[Y]),all(Table[Z])))

[Ashish_Mathur]

Hi,

In the Query Editor this should be easy to do.  Insert an Index column.  Select that column and "Univot other columns".  Remove all columns except the Value column.  Remove duplicates from the Value column.

Hope this helps.