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

    Previous Month expresion

    Jacek Stypulkowski

      Hello,

       

      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

      rgds

      Jacek