1 Reply Latest reply: Apr 28, 2016 1:56 PM by Gysbert Wassenaar RSS

    Dimension Help

    Alex Tomlinson

      I want to group some dates in a dimension using the below expression:

       

      if([New/Existing]>MaxString({<Date=,Month=,Year=,MonthYear=,PeriodNum={"$(=Max(PeriodNum))"}>}[MonthYear])-12,'Yes','No')

       

      the dates I am using are :

       

       

      I want to attach values to the yes or no grouping based on the formula above, so when I change date the formula is dynamically changing.

       

      The expression above returns an invalid dimension, can anyone help me