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]




      Ending HC100200250300