Forum Discussion

dinoscool3's avatar
dinoscool3
Helper II
3 years ago
Solved

Count Duplicates after First Date

I have a table of registration data, I have set up a column that counts how many times someone has registered, however I also want a count of who has registered after the date of their first registra...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, dinoscool3 ;

    Try it.

    Measure = CALCULATE(COUNT('Table'[email]),FILTER(ALL('Table'),
                    [email]=MAX('Table'[email])&&[date]>CALCULATE(MIN('Table'[date]),ALLEXCEPT('Table','Table'[email]))))+1

    the final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, dinoscool3 ;

Try it.

Measure = CALCULATE(COUNT('Table'[email]),FILTER(ALL('Table'),
                    [email]=MAX('Table'[email])&&[date]>CALCULATE(MIN('Table'[date]),ALLEXCEPT('Table','Table'[email]))))+1

the final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.