Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anybody help find error in below expression .I tried but guess I need extra pair of eyes to look .
trying to create a calculated dimension but it error's out .
=only({<[%KEY]={'Ariel'},DATE={>=EndMonth12<=END_DT},Domain1=,Domain2=,Domain3=,Domain4=,Domain5=,Metric=>}MonthYear)
End Month & END DT are fields in my data set.
Help is much appreciated!
Try
=only({<[%KEY]={'Ariel'},
DATE
={">$(=Max(EndMonth12)) <=$(=Max(END_DT))"},
Domain1=,Domain2=,Domain3=,Domain4=,Domain5=,Metric=>}MonthYear)
nope still give invalid dimension
I don't see anything wrong in the expression.
Make sure your Max(EndMonth12), Max(END_DT), DATE are in same format.