Forum Discussion

Copper Contributor

Mar 20, 2020

Join columns from different tables in the data model

Hi, In Excel Data Model I have a fact table and a few dimension tables connected to it. What I'd like now to do is to create a view in Excel that I can pull data from my tables together. I don't ...

excel

SergeiBaklan

Diamond Contributor

Mar 20, 2020

Nima Mohandesan

You may create linkback table, step by step instruction is here https://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013/

Nima Mohandesan
Copper Contributor
Mar 20, 2020
SergeiBaklan Thank you, it seems like since this has been written things have moved around. I couldn't find the Table connection as it starts the instruction with.
- SergeiBaklan
  Diamond Contributor
  Mar 20, 2020
  Nima Mohandesan
  
  You may have query which added data to data mode. In general any query works which loads something to data model. You may select it from the list and add to resulting table desired DAX expression.
  - Nima Mohandesan
    Copper Contributor
    Mar 21, 2020
    So I was able to flatten the data via a new query that pulls from my Fact and Dim tables. then I used the linked table to bring that table into the data model for DAX. But since this new table is not part of the data model is just hanging there in the model. Would that be ok? What would work better? SergeiBaklan