4 Replies Latest reply on Dec 20, 2016 5:15 AM by Paul Damen

    Create measure for current year

    Paul Damen

      All,

       

      I have a Date field and a measure field with revenue.

       

      What I want to do is create a measure that shows the Revenue for this year (so without having to do a filter but just 1 standard measure for current year)

       

      I tried like this but that doesn't work: IF Year(Date) = Max(Year(Date)) THEN Revenue END

       

      Could you guys help me out?

       

      Regards, Paul