Ho to combine two columns into one?

[marcoarib]

I have two columns:

- Authors -
John
Mary
Jane

- Sellers -
John

Mary

Ronald

- Final Column -
John
Mary
Jane

Ronald

How can I do that on Power BI?

Is it possible to do it with DAX?

Thanks.

[Krutigawale33]

Hello @marcoarib ,

Create new Table and paste the DAX:

New Table =

VAR newTable =

UNION (

SUMMARIZE(table1, Table1[- Authors -]),

SUMMARIZE(table2, Table2[ -Sellers-])

)

RETURN

SUMMARIZE(newTable, Table1[- Authors -])

That will create final column with name -Authors-

[marcoarib]

Thank you.

[amitchandak · Accepted solution]

@marcoarib , Like

new table =distinct(union(all(Table[author]),all(Table[Seller])))

this will give a new table.

You can use that.

Or use this as dimension and join with both columns (one active, one inactive) . Use userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Then you can create measure add count from both joins

[marcoarib]

It works. Thanks a lot!