In the table above , I have Calendar Month linked to our financial year and period. The month index is calculated by taken Financial Year x 12 + Financial Period. So for eg, Sept 14 , the month index = (2015 x 12) + 5 = 24185.
In my variable overview , i have created a max (MonthIndex) and called it vMaxMI. In my expression label, if i say =vMaxMI, then the result is 24185. However, if i want to display the Calendar Month (ie Sept 14), I have tried :
if ([Month Index] = vMaxMI, [Calendar Month]) , but this does not work. I have tried several other variations, but still no success.