Forum Discussion

mcornfield's avatar
mcornfield
Icon for Helper III rankHelper III
6 years ago

DAX Question (Querying Data with DAX combine data from two tables)

Hello,

I am new to DAX and am pulling Tabular Data from Analysis Services. There is a lot of data and I only want to pull certain columns from different tables in the cube. I can pull a couple of columns from one table but not sure how to combine it. Please see the screenshot below any help with writing this query would be appreciated.

For example, I want to see [Region] from 'Companies' and [State] from 'Houses'