Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |