1 Reply Latest reply on Aug 11, 2017 5:12 PM by Zhouyi Zhang

    Distinct Count on the basis of two columns

    rohit Kandalkar

      Hi All, I am facing problem. It is very basic. I want to count number of students on the basis of two columns ie. StudentID and Date. Here is an example:-

      Student ID and Date

      1                         01/02/2017

      2                         01/03/2017

      2                         01/03/2017

      1                         01/03/2017

      3                         01/03/2017

      3                         01/03/2017

      2                         01/04/2017

       

      So here my answer is coming 3 as it only counts distinct StudentID but not the Combination of both. I tried using GroupBy. The answer I am expecting is 5.

      Thanks