Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 ,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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |