Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try : =Max({1} [Fiscal Month])
HTH
Sushil