Combine 2 columns from different tables

[Anonymous]

Hi, i have 2 columns from different tables and i want to combine row by row

i.e:

table1 column num :  Table2 column letras 

And i want my result like this:

Thank u for your help!

[camargos88 · Accepted solution]

Hi @Anonymous ,

You can do it using DAX like (for a new table):

CrossTable = CROSSJOIN(Letras, Num)

On Power Query, just create a custom column and use the table name as reference, if you have more columns use like:

TableName[Column] and just expand the list.

[Mariusz · Accepted solution]

Hi @Anonymous 

You can use DAX CROSSJOIN function to create a table

https://docs.microsoft.com/en-us/dax/crossjoin-function-dax

Or in Power Query just add a Custom column with the syntax like below.

= tablename[columnname]

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[camargos88 · Accepted solution]

Hi @Anonymous ,

You can do it using DAX like (for a new table):

CrossTable = CROSSJOIN(Letras, Num)

On Power Query, just create a custom column and use the table name as reference, if you have more columns use like:

TableName[Column] and just expand the list.