Forum Discussion
How would you model this ?
curiouspbix0 Yes sir
curiouspbix0 , did not get it completely, but if it import or mixed model, you should able to create tables using
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
In DAX we use +0, or Show item without data for left join.
My question is more inline to an optimal model for the req at hand.
Not on how to do it literally on Power Query actually.
1. Join master tables on left to the transacational table on right with huge volume to write a new dataset on power query.
2. Keep the master table seperate to transactional table in power query and later join them in DAX data model ?
3. Other optimal options ?
Any inputs from the experts ?
curiouspbix0 I don't see any reason you need to merge in power query, it is typical dim and fact model.
Only thing I'm not clear what is the difference between A and B since both have City data?
If these two have different cities, I would recommend to append this in power query and make one city dimension and make sure it is unique (remove duplicate values)
From here everything will be super easy to work with and you will have the most effective model.
I hope it helps.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Thanks Parry, there is more to the city table too which is not only master.
Like Cities would be listed by dates on the master table and could repeat so it is a more than typical master data table, was just trying to simplify for ideas.I will stick to typical model principles then.
