Hi, I am trying to create a Boolean metric with Month as the only dimension member. I want to write a formula where if the month is greater than eg. “April 2025” and less than or equal to ‘Last Actual Month’ (Month dimension property member of ‘Save Version’) of ‘Save Version’.”Live Version” then TRUE but I am having trouble calling the ‘Last Actual Month’ of ‘Save Version’.”Live Version”.
I think ideally I would be able to pull something like ‘Save Version’.”Live Version”.’Last Actual Month’ but surely it can’t be that simple? 
Page 1 / 1
if(Month>Month."Apr 25" and Month <= '32. Last Actual Month'nselect lastnonblank:'32. 3Dim] Save Version'."Live Version"],true)
if(Month>Month."Apr 25" and Month <= '32. Last Actual Month'nselect lastnonblank:'32. 3Dim] Save Version'."Live Version"],true)
That worked, thank you!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.