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

    Calulating Client ID within specific Dates

    Martin Hommes

      Hi,

       

      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