5 Replies Latest reply: Mar 1, 2017 2:55 AM by Shraddha Gajare RSS

    Previous Month expresion

    Jacek Stypulkowski



      can anybody help please


      I have used and following expression to sum the values for current month which works fine:

      SUM({$<[Date]={'>=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))'}>}[Sales Actual])


      I need to find separately values for previous month trying below expression, but it doesn't work:


      SUM({$<[Date]={'>=$(=MonthStart(Today()),-1))<=$(=MonthEnd(Today()),-1))'}>}[Sales Actual])


      Any suggestion please