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. ...
v-caliao-msft
Microsoft Employee
Microsoft Employee
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.
Wes
hope this message finds you well. Just wondering if you had the chance to look at the file I sent?
Thanks,
Wes