Forum Discussion
substring
Thank You.One more query.How can i add columns from two or more tables to a new a table.
I want to add col1 from table 1 and col1 and col3 from Table2 to a new table 3 using DAX
Table1 Table 2
col1 col2 col3 col1 col2 col3 col4 col5
Tabl3(New)
col1 col2 col3
Hi Surya1
You must have a common key to join them
If you dont have it....You can add an Index Column from Query Editor and then join the 2 tables on it
Then you can easily combine tables using "RELATED" Dax function
the join should be performed using the query editor?
HI Surya1
You can use Query Editor as well
With Query Editor
1) First Add an Index Column in both Tables
2) Now join the tables using Index Column
3) Use merge queries (Transform Tab) to join the 2 Tables