I have a call log that is a child table to my evac record. I want to be able to display the most recent call date/time column in a view I have for the evac record. If I create a virtual column in the evac record table is there an expression I can use to display the most recent date/time from the call log for the person?
Something along the lines of this should work for the virtual column:
MAX(SELECT(Related Calls[DateTime],TRUE))
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |