Forum Discussion
Combine 2 columns from different tables
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!
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.
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
2 Replies
camargos88Community Champion
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
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