cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pedroccamaraDBI
Helper IV
Helper IV

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 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

1 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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

Capture999.jpg

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Thanks a lot @amitchandak 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors