'Combine columns from different tables to make one table Power BI DAX

I have three different tables. I want to select different columns from each of the tables and create one table based on some filters. Have a look at the following dax expression:

FILTER(DISTINCT(SELECTCOLUMNS(Test_Table,"site_key",[site_key],"is_active",[is_active])),[is_active]=TRUE&&[dbsource]=="DB2")

As you can see, I've selected olumns from Test_Table.

Firstly, How can I add columns from the other two tables?

Secondly, please note that these tables are related so I've created a relationship between them based on relevant IDs.

Will I have to create a natural join in DAX as well?

powerbi dax

Solution 1:^[1]

As I mentioned in the comment, SUMMARIZECOLUMNS can probably get you what you're looking for. It might look something like this in your case:

SUMMARIZECOLUMNS (
    Test_Table[site_key],
    Test_Table_2[industry_group],
    Test_Table_2[country],
    Test_Table_2[state],
    FILTER ( Test_Table, [is_active] = TRUE && [dbsource] = "DB2" )
)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Alexis Olson

'Combine columns from different tables to make one table Power BI DAX

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]