Populate latest date of interaction from another table

[JBGreenpaths]

Hello,

I have a stores table that I need to populate a virtual column with the latest date from a visits table. 

I've tried a sort function with a max row but I can't get it to further sort by the store ID (which is in key and ref respectively)

[Marc_Dillon · Accepted solution]

Should be able to do:   MAX(SELECT( visits[date] , [store] = [_THISROW] ) )   ...no?

[JBGreenpaths]

Thank you. I was irritatingly close 

[Marc_Dillon]

Great. Actually on second thought, probably just : MAX( [Related Visits][Date] )