Forum Discussion
pedroccamaraDBI
Post Partisan
Post PartisanRELATED or RELATEDTABLE?
Hey guys, I hope you can help me on this 1. I have 3 tables, main project, with project number, name, date and so on, Expenses table, with expenses type, value, date, etc and Time table, with tasks...
pedroccamaraDBI , In two table models you should able to work with common dimensions. But you plan to use summarize to create a table in Dax , better to do in power Query
amitchandak
Super User
Super UserpedroccamaraDBI ,Can you share sample data and sample output in table format?
prefer to use merge in power query
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
pedroccamaraDBIPost Partisan
Post PartisanYes amitchandak i did it with merge first, and it works, but somehow, i think it would be faster, cleaner and simple with a virtual table, in this case 2 tables.
Here's the visual
- amitchandak
pedroccamaraDBI , In two table models you should able to work with common dimensions. But you plan to use summarize to create a table in Dax , better to do in power Query
- pedroccamaraDBI
Thanks a lot amitchandak