How do you look up a value from an earlier date in a different table

[Anonymous]

I am attempting to look up a value for the end of the month from a different (update/Maintenance History) table by account. 

However, when using the lookupvalue function based on both the account and month End date, I only return matches if an update to the maintenance history table occurred in that respective month. How Do I lookup the value from the other table when there is not a matching date? I need to pull the value for the earlier date of occurence. See Below for an example of what is happening and for what the desired result should be.

[vojtechsima · Accepted solution]

Hi, @Anonymous,
see my solution:

Value = maxx(filter(Updated,PrimaryTable[Month End Date]>=Updated[Month End of Updated Date]),Updated[Value])