How to add a column in a table from another table

[Anonymous]

Hello guys,

I have this table here, that has these columns which I union from the SQL Query:

select distinct

aa.*

from (
select
cod_grupo_empresa,
hashcodevida,
data_ref

from tb_contaspagas

union all

select
cod_grupo_empresa,
hashcodevida,
data_ref
from tb_cadastro

) as aa

but now I want to add a extra column, however, it only exists in one of the tables mentioned in the SQL Query, which doesn't allow me to add it on the query since it requires the same number of columns, in order to union the tables. Is there any way that I can bring this extra column to my table using DAX?

[judspud · Accepted solution]

Hi @Anonymous ,

You can import the table that contains the additional column as a separate query and merge the column to the table using the merge function in query editor

Thanks,

George