4 Replies Latest reply on Sep 11, 2019 12:24 PM by Bryce Larsen

    How to do distinct count on a measure with max date only?

    Terka

      This seems to be very simple but I can not seem to find the answer in previous forums.  I am looking to do a distinct count on a employee ID but only with max data date but want to do in Calculated field.   Below is an example of the data.. the answer I should get is 2.  Any assistance would be appreciate it.

       

      Data DateEmployee ID
      Jun-19123456
      Jun-19123457
      Jun-19123458
      Jul-19123456
      Jul-19123457