4 Replies Latest reply on Jun 8, 2018 11:40 AM by Bryce Larsen

    prior month count

    kevin smith

      Hello happy Friday all,

       

      In my data set there is a ASOF_DATE(day/month/year) (only monthly date in here ex. 1/31/17,2/28/17...) field and "number of record"  measure

       

      I want to create a measure that will sum up the number of records in prior months date

       

      for example my ending HC would be number of records by ASOF_DATE, my beginning would be prior month ending HC.

       

      I tried the IF statement  but its not working as intended. as help would be appreciated.

       

      if [ASOF_DATE] = (#2018-02-28#)-month(#2018-01-31#) then [Ending HC]

      end

       

       

      JanFebMarApr
      Beginning50100200250
      Ending HC100200250300