create table from different column of different tables

[Anonymous]

 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

[TeigeGao · Accepted solution]

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