Forum Discussion
Create a Calculated Table from 4 separate tables
For what's worth, this is not the best solution. Just because you can create this table in Dax, doesn't mean you should. Best practices is to do the data shaping in power query (get data) and do the modelling only in power pivot.
Read this article I wrote here http://exceleratorbi.com.au/shaping-modelling-power-bi/
Yes Matt. you are correct that its not the correct approach.
Yesterday in the above model, i had Unique Branch ID's so i was able to make One to One relationship between Branch and Order table but today after moving to another server, there were multiple orders from the same Branch and i no longer was able to maintain One to One relationship between Branch and Order table instead had to shift to Many to One relationship. this way, i cant write a DAX query like yesterday with ADD COLUMN to create a Calculated Table. there you go, i'm back to the same problem.
MattAllington - since the data model is designed in such a way, is there any other solution to overcome this issue to create a Calculated Table? thanks for your help.
ankitpatira I saw your comments on the can't create relationship between tables because one of the columns must have unique values. i satisfy that condition here but still facing a problem to create a Calculated Table. much appreciate your help.
anguyen83 MiguelMartinez - can you guys throw some light as well? thank you.