3 Replies Latest reply on Oct 30, 2016 11:15 AM by Norbert Maijoor

    Consecutive appearances based on most recent date

    Anush Patel

      Hi,

       

      I have a dataset where I need to find the number of consecutive appearances based on the most recent date. Ideally, I would like it to be dynamic whereby whatever measure I drag in, the calculation will do its work. Simple Example attached.

       

      Thanks in advance

       

      Anush