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...
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
camargos88
Community Champion
Community ChampionHi 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.