Set analysis - Max date

[george456]

Dear Community

= Only({<MonthYr = {"$(=max({1}MonthYr))"}>})

The above is a syntax that I am using but it is giving no output. Please advise

Regards

[dplr-rn]

couple of things
1- you have not specified a column for the Only function. I am assuming that it is there in the actual code.
2- what is the output for max({1}MonthYr)

[george456]

Hi

The output must refer to the latest date in my data . In this case it would be Jul 2019. The output must not change with any selections made in the data. 

I want to use this Latest Date ( Max Date ) as a variable in other calculations

Regards

[dplr-rn · Accepted solution]

so why use only?

just use max({1}MonthYr) in the variable.

I am assuming MonthYear is a date field

[george456]

Hi

Thanks for help. All is good now

Regards