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

    Create measure for current year

    Paul Damen



      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