Select minimum value from fiscal year

[siddharthsoam]

I  want to select minimum value from my fiscal year column FY16 and FY17 and store it in a variable. But then when I select a value in the fiscal year filter the variable's value gets changed

[shraddha_g · Accepted solution]

if you want to fix this value and should not affect from any selection then you can use

Max({1}YearField)

Use it according to your expression

[ali_hijazi]

create a variable and in let the definition starts with = sign

and the definition would look like something like this:

=Max({1}year)

where {1} is the whole set of data regardless of any selection you make on the dashboard

[siddharthsoam]

Hi Shraddha,

Its working fine the value of my variable is fixed, but due to this other filter selections are not working.

[ali_hijazi]

can you share a sample application to investigate it

[shraddha_g]

Max({<YearField=>}YearField)