Forum Discussion
Calculate Column based on columns from multiple tables
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
3 Replies
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
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.
Weshope this message finds you well. Just wondering if you had the chance to look at the file I sent?
Thanks,
Wes
