5 Replies Latest reply: May 30, 2016 7:15 AM by Stefan Wühl RSS

    Set analysis smaller than current Month

    Jurien Groot

        Hi,

       

      I am trying to get Sales smaller than current month.

       

      Below works fine for current month.

       

      Sum({$<Month={'$(=Month(Today()))'}>}[Sales])

       

      When adding:

      Sum({$<Month={<='$(=Month(Today()))'}>}[Sales])


      It doesn't work. I tried so many variations..


      Some help would be very much appreciated!