Count of emails by categories from present row to the previous rows of the category

[Anonymous]

Hey guys,

I need help. I would have to count the emails by categories, but I don't know how to count ir from the present row to the previous in the same category email.

For example, I have 6 emails (RRHH[emails] from 3 different categories:

xavipp@gmail.com (Count the present email. Result1)

xavipp@gmail.com (Count the present mail and the previous. Result:2)

xavipp@gmail.com (Count the presnet mail and the 2 previous. Result 3)

marcpp@gmail.com (Count the present mail. Result 1)

marcpp@gmail.com (Count the present mail and the previous. Result:2)

reivaxpp@gmail.com Count the present mail. Result 1)

Thanks!!

[AnkitKukreja · Accepted solution]

Hi @Anonymous 

It's achievable, but would request you to share the pbix file for some ss of your data so that i can provide you with better solution.

Thanks,
Ankit Kukreja

Linkedin 

[lbendlin]

what's your index column (the one that guarantees the sort order)? 

You can use that column to identify the switchover from one email to another.