Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a month field where the data is like May-16,Jun-16.
Now my requirement is i need to get last year. For example when i select May-16 i should get May-15.
I have given max(month)-12 but it is converting to integer..like 42479..Can you please help me on this..
Thanks,
Bharat
See attachment
Thanks a lot Antonio..I don't know where i missed it..Can you please tell me..
try like this last year may-15 data
=sum({<DATEFIELD={">$(=Date(addMonths(min(DATEFIELD),-12))<=$(=Date(addmonths(max(DATEFIELD),-12)))"}>}measure)