Forum Discussion
Solved
RELATED 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
pedroccamaraDBI ,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
Yes 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
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
Thanks a lot amitchandak
