cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wes-shen-poal
Helper III
Helper III

Calculate Column based on columns from multiple tables

Hi there,

 

Below is my model:

 

ERD.PNG

 

I would like to calculate a column in the 'inv_unit' table, that gives me the 'srv_event'[placed_time] for each gkey (or row) in the 'inv_unit' table.

 

but because there are multiple 'srv_event'[placed_time] for a given 'inv_unit'[gkey], the criterion for choosing the correct 'srv_event'[placed_time] is where 'srv_event_types'[id]="UNIT_LOAD"

 

Please can someone kindly help me by telling me what my calculated column formula in 'inv_unit' data table should look like to achieve this?

 

Thanks in advance for your help


Wes

3 REPLIES 3
v-caliao-msft
Microsoft
Microsoft

@wes-shen-poal,

 

We can use FILTER and RELATED function to get value from another table. If you could provide us some sample data, we can try to figure out the detail formula.

https://msdn.microsoft.com/en-us/library/ee634202.aspx

 

Regards,

Charlie Liao

hi @v-caliao-msft

 

Thanks for looking into this for me.

 

I've just sent you a private message with a link to the pbix file. I hope that's ok.

 

Thanks again in advance for your help.


Wes

hi @v-caliao-msft

 

hope this message finds you well. Just wondering if you had the chance to look at the file I sent?


Thanks,
Wes

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.