Creating Benchmarks from Previous Year

Comments

4 comments

  • Avatar
    Michael Becker

    Why not use PASTYEAR instead of this and do the calculation in the dashboard formula? - PASTYEAR(COUNT[Value])*1.03

    0
    Comment actions Permalink
  • Avatar
    Joseph Polefrone

    Michael,

    The issue we have is that it does not constitute for the DayOfWeek... Any suggestions?

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Joseph,

    Correct me if I'm wrong but if let's say today is 12/06/2018 and it is a Tuesday, you want to comapre it against closest Tuesday to 12/06 last Year? Did I get it right?

    0
    Comment actions Permalink
  • Avatar
    Joseph Polefrone

    Correct

    0
    Comment actions Permalink

Please sign in to leave a comment.