Max Date into the Expression

[asknyldz]

Hi,

I found max date in my data with this expression,

=max({<TYPE={'MACTUAL'}>}[MONTH])

The result is,

01/03/2016

Thats ok, but i want to set this formula in this expression, i don't want to write manually the date.

(sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]),MONTH={'<=01/03/2016'}*P(MONTH)>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

Regards,

[sunny_talwar]

May be this:

(sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]),MONTH={"<=$(=Max({<TYPE={'MACTUAL'}>}[MONTH]))"}*P(MONTH)>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000