Forum Discussion

powerbient's avatar
powerbient
Frequent Visitor
9 years ago

Create a Calculated Table from 4 separate tables

I am trying to calculate a table by getting columns from 4 different tables as listed in diagram. i am unable to get it through DAX queries i searched online like relatedtables, filter, add columns e...
Need Help
MattAllington's avatar
MattAllington
Community Champion
9 years ago
powerbient wrote:

MattAllington - since the data model is designed in such a way...

 

What do you mean by this?  The data model is designed by you (the report author and data modeller). You need to make decisions on how to load the data and then how to work with it - this is data modelling. Your statement seems to suggest you don't have any choice in the matter. Maybe I have missed something. 

 

Here is an article I wrote that you may find useful. 

http://exceleratorbi.com.au/shaping-modelling-power-bi/

powerbient's avatar
powerbient
Frequent Visitor
9 years ago

Hi Matt, 

 

thanks for the reply. I have to go with that model and cant change it. anyways, rather than writing DAX, i used merge functionality in PBI Desktop to achieve the above explained issue.

  • MattAllington's avatar
    MattAllington
    Community Champion
    9 years ago
    powerbient wrote:

    I have to go with that model and cant change it. 

     

    This statement does not make any sense.  The data model is what you build in Power BI, so it can be what ever you want it to be - that is what the Power BI Desktop tool is for!  It is irrelevant how the data is shaped at the source - you can change it during load so it meets your needs.