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
Mariusz
Community Champion
Community ChampionHi 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
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.