RELATED or RELATEDTABLE?

[pedroccamaraDBI]

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 description, dates, values, etc.

I'd like to, every time i choose a project name or number, shows me everything about it of the project table and then, i would like to create a virtual table for each expenses and time table like this:

Data Expenses =
SUMMARIZECOLUMNS ( 'Tab Expenses( tm_debitos )'[Proj ID],
'Tab Expenses( tm_debitos )'[Client Name],
'Tab Expenses( tm_debitos )'[Date Rec],
'Tab Expenses( tm_debitos )'[Employee],
'Tab Expenses( tm_debitos )'[Value] )

But with a filter to the Project ID. Something like this:

FILTER Tab Main Project [Proj ID] = Tab Expenses [PRoj ID] or should i do it with a VAR?

I hope i was clear enough for you to help me

Thanks a lot

Pedro

[amitchandak]

@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

[pedroccamaraDBI]

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

[amitchandak · Accepted solution]

@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