How to combine two column into one.

[tkconsultingnl]

Hi guys,

I have a little issue, I wanted to combine 2 coloumn into one. To be clear here's what I'm trying to achieve in the image below. So the new coloumn should have everything in rows.

I need some Dax formular to achieve this please.

[johnt75 · Accepted solution]

You could create a new table like

New Table = DISTINCT( UNION(
ALLNOBLANKROW('Table1'[Column1]),
ALLNOBLANKROW('Table1'[Column2])
))

[tkconsultingnl · Accepted solution]

Hi John,

Thanks for your help, it worked perfectly as I wanted.

Much appreciated 

[johnt75 · Accepted solution]

You could create a new table like

New Table = DISTINCT( UNION(
ALLNOBLANKROW('Table1'[Column1]),
ALLNOBLANKROW('Table1'[Column2])
))

[tkconsultingnl]

Hi guys,

I have a little issue, I wanted to combine 3 coloumn into one. To be clear here's what I'm trying to achieve in the image above. So the new coloumn should have everything in rows. But the challenge I have is the Blank row. How can I fixt it please.

Treat as urgent