Creating a variable

[rido1421]

Hi There

I am trying to create a variable for max date but it should look at max date regardless of the selection

vMAXPERIOD=Max(Fiscal Month)

I have a fiscal month selector on my dashboard but in a certain expression I want to use an if statement saying if the fiscal month = vMAXPERIOD , expression , 0

problem is with the Max(Fiscal Month) it looks at the max of the selected fiscal month

Thanks

[sushil353 · Accepted solution]

Hi,

Try : =Max({1} [Fiscal Month])

HTH

Sushil