Dear All, I have below 2 expressions on same dimension, and they both work,
what i want is to replace '2014/2/26' with return of Exp2
but i failed, no matter i try using the expression name,
the whole Exp 2, the $(= ) expansion, and i am quite sure that Exp2 return '2014/2/26' on that dimension.
anyone can help and explain? Many Thanks!
Exp1: only( if([Price start date]<='2014/2/26' and [Price end date]>='2014/2/26' and [Price price center] = [Price center], [Original price] ))
Exp2: max({$<[Onfloor date]={'<=$(=MAX([Manual calendar date]))'}>}[Onfloor date])