Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 registration. Here's my example with the last column being what I need:
date | Duplicate? | Duplicate after first day? | |
joe@joe.com | 8/25/2022 | 2 | 1 |
joe@joe.com | 8/25/2022 | 2 | 1 |
bob@bob.com | 8/26/2022 | 1 | 1 |
Mary@mary.com | 8/26 | 3 | 2 |
Mary@mary.com | 8/26 | 3 | 2 |
Mary@mary.com | 8/27 | 3 | 2 |
I don't need it as a column, a measure would also work as I'm adding it into a table visusal. Thank you!
Solved! Go to Solution.
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.
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.
@dinoscool3 , for Joe, duplicate after the first day should be 0 ?
For you case try like
a new column =
if([Duplicate] >1, [Duplicate]-1, [Duplicate])
I don't think that would work because if Joe had three registrations on the first day if I did that he'd still be 2, unless I'm missing something.
Essentially, I want to count any registrations after the first day they registered. But the first date is variable based on the person.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
77 | |
69 | |
69 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |