Forum Stats

  • 3,784,367 Users
  • 2,254,929 Discussions
  • 7,880,792 Comments

Discussions

How to find value of same date in last year

933930
933930 Member Posts: 45

I want to know How to find value of same date in last year.

Now, I use ago function with year and the result is

YearRevRev Ago
20113000
201240003000
201320004000
201450002000

it works but it is not which I want. I try to add date column (Ex.20140101) to my report but it'snot work.

I want to show:

DateRevRev Ago
20110112200
20120112100200
20130112300100
20140112500300

if use (<measure>, <time_dim>.<date>,365), it works but not correct 100%

Please help me..

Thanks a lot

SriniVEERAVALLI

Best Answer

Answers

This discussion has been closed.