How to join two columns from two tables into two columns in another table

[Anonymous]

Hi, I have two columns in two different tables.

I should create a calculated table that unites the first column of the two tables into one column in the calculated table and then joins the second column of the two tables into a second column in the computed table.

I tried to use the UNION command, but I was able to do only one column.

The command I created now generated the "Conta" column.

= 
DISTINCT(
      UNION(
           SELECTCOLUMNS(Orcamento;"Conta";Orcamento[NROCONTACONTABIL]);
           SELECTCOLUMNS(Realizado;  "Conta";Realizado[NroContaContabil])
      )
)

But now I need to join another column, with descriptions related to the generated numbers.

These descriptions are in different tables:

Realizado[DescrContaContabil]
Orcamento[descrconta]

[v-juanli-msft · Accepted solution]

Hi @Anonymous

you can add the second columns from two tables to the formula you created.

I make a test by the formula below and get a mew table with two column generated from two columns from two tables.

Table = DISTINCT(
      UNION(
           SELECTCOLUMNS(Orcamento,"Conta",Orcamento[NROCONTACONTABIL],"sy",Orcamento[descrconta]),
           SELECTCOLUMNS(Realizado, "Conta",Realizado[NroContaContabil],"sy",Realizado[DescrContaContabil]
      )
))

If you have any question, could you share me some detailed data and result you want.

Best Regards

Maggie