Joining/Appending Tables with Calculated Columns

[JCPO]

Hi Guys,

I have a simple problem which I cant get around. 

I have two tables (A and B) with some similar column names. Basically, I want to create a new table based on similar column names and append it to each other. I can't go through the append query since I have a calculated column. 

Sample result

Which expression to best produce the result? 

Thanks!

[amitchandak · Accepted solution]

@JCPO , Try like

union(
selectcolumns(table1,"ColA", table1[Column A],"ColA", table1[Column B],"ColF", table1[Column F]),
selectcolumns(table2,"ColA", table2[Column A],"ColA", table2[Column B],"ColF", table2[Column F])
)

Or

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[camargos88]

Hi @JCPO ,

You can do it using Power Query, if the column names are the same, it will append.

How is your calculated column ? Can you do it after append them ? If no, it will apply only for the table you are creating, leaving null values for other appended tables.

Ricardo