set Analysis help

[arusanah]

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!

[vamsee]

Try

=only({<[%KEY]={'Ariel'},

DATE

={">$(=Max(EndMonth12)) <=$(=Max(END_DT))"},

Domain1=,Domain2=,Domain3=,Domain4=,Domain5=,Metric=>}MonthYear)

[arusanah]

nope still give invalid dimension

[vamsee]

I don't see anything wrong in the expression.

Make sure your Max(EndMonth12), Max(END_DT), DATE are in same format.