Date <= Chart Date Dimension

[#1]

I have a dimension in script

Table1:

SYMBOL

ASOFDATE

Value

table2:

SYMBOL

UPdateDate

Value

I create a chart with a dimension symbol, AsOfDate.

I need a calculated expression that get the max UpdateDate where UpdateDate <= asOfdate.

I tried the following except

=DATE(Max({<UPdateDate= {"<=$(=Max(AsOfDate))"}>} UPdateDate))

Unfortunate;ly if i have 7 asOfDatesit compares it to the Largest date  and I want it to be compared to the Date in the Chart dimension.

How do i accomplish this?