Create new table with one column containing all the values.

[SanketBhagwat]

I want to create a new table with just one column containing all the values from other table.

I have 3 columns named groups, divisions and functions in one table and I want to create a new table including just one column with all the values of those 3 columns from that table.

If someone knows the solution,then do please let me know.

Regards,

Sanket Bhagwat

[amitchandak · Accepted solution]

@SanketBhagwat , Try a new table like

union(all(Table[Name]),all(Table[group]),all(Table[division]))

or

distinct(union(all(Table[Name]),all(Table[group]),all(Table[division])))

[Jihwan_Kim · Accepted solution]

Hi, @SanketBhagwat 

Please check the below for creating a new table.

New Table =
UNION (
VALUES ( 'Table'[Divisions] ),
VALUES ( 'Table'[Functions] ),
VALUES ( 'Table'[Groups] )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak · Accepted solution]

@SanketBhagwat , Try a new table like

union(all(Table[Name]),all(Table[group]),all(Table[division]))

or

distinct(union(all(Table[Name]),all(Table[group]),all(Table[division])))