Forum Discussion
wes-shen-poal
Helper III
9 years agoCalculate 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. ...
v-caliao-msft
Microsoft Employee
9 years ago
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-poal9 years ago
Helper III
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-poal8 years ago
Helper III
hope this message finds you well. Just wondering if you had the chance to look at the file I sent?
Thanks,
Wes