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
Solved! Go to Solution.
@pedroccamaraDBI ,Can you share sample data and sample output in table format?
prefer to use merge in 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
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.