Date before from another table

[Ronald123]

Hello,

Can someone help me with this?

I have two table without any relationsship.

I need a calculated colum in the PayTable from the CallsTable.

The calculation rule is the first date from the CallsTable but not equal.

Greetz, 

Ronald

[v-yuta-msft · Accepted solution]

Hi Ronald123,

To be general, are date in column Table Calls[CallDate] unique? To use lookupvalue(), or other similar function like related(), you should build a one-many relationship between the two tables, then use column in one-side as a filter condition to achieve the value you want.

Regards,

Jimmy Tao