Forum Discussion
create table from different column of different tables
Hi,
I am trying to built a table which needs to contain different columns from two different related tables.Table 1 contains two column (let say description and subdescription);table 2 contains several measures and one related column from table 1 (1 to 1 mapped, with subdescription). Please suggest how could I achieve that.
What I was trying with SELECTVALUES and ADDVALUES on create table option but it takes only one table column and doesnot allow other table.Also I ve tried with append query but its just putting NULL values in related columns.
Please
Hi pundiv01,
According to your description, my understanding is that you want to create a table with some columns from different tables. In this scenario, we can use the ADDCOLUMN() and SELECTCOLUMNS() function, please refer to the following example:
Create two tables ‘Table1’, ‘Table2’ like below:
Then use the following DAX query to create a table:
Table = ADDCOLUMNS(SELECTCOLUMNS(Table1,"Description",Table1[description]),"Column1",MIN(Table2[Column1]),"Column2",MIN(Table2[Column2]))
The result will like below:
In your scenario, you may need to change DAX to “Table = ADDCOLUMNS(SELECTCOLUMNS(Table1,"Description",Table1[description]),"Column1",Measure1,"Column2",Measure2)”.Best Regards,
Teige
1 Reply
TeigeGaoSolution Sage
Hi pundiv01,
According to your description, my understanding is that you want to create a table with some columns from different tables. In this scenario, we can use the ADDCOLUMN() and SELECTCOLUMNS() function, please refer to the following example:
Create two tables ‘Table1’, ‘Table2’ like below:
Then use the following DAX query to create a table:
Table = ADDCOLUMNS(SELECTCOLUMNS(Table1,"Description",Table1[description]),"Column1",MIN(Table2[Column1]),"Column2",MIN(Table2[Column2]))
The result will like below:
In your scenario, you may need to change DAX to “Table = ADDCOLUMNS(SELECTCOLUMNS(Table1,"Description",Table1[description]),"Column1",Measure1,"Column2",Measure2)”.Best Regards,
Teige