Calculate Column based on columns from multiple tables

[wes-shen-poal]

Hi there,

Below is my model:

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

[v-caliao-msft]

@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

[wes-shen-poal]

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

[wes-shen-poal]

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