3 Replies Latest reply: Jun 9, 2016 5:25 AM by Stefan Wühl RSS

    Calulating Client ID within specific Dates



      I would like to count Customer IDs (distinct customer IDs) with specific dates.


      The format of the date column is:

      1-1-2012 (Day-Month-Year)


      I would like to count the Customer IDs by a given year. For example: 2012


      I have tried several functions:

      if(Date>='01-01-2012' AND Date<'01-01-2013',Count(Distinct([Customer ID])))

      If(Year(Date)=2012,Count(Distinct([Customer ID])))


      Can you please help me with this function?


      Thank you!


      Best regards,

      Martin H