Hi Harsh
I have stripped out identifyable information and cut the dataset down.
As can be seen from the dashboard it calculates those donors that have donated every year for up to 10 years.
What I need to do is from the database of all donation, identify the ones that have donated every year the longest periods. That is, they may have stopped donating, but were a loyal donor.
Also note, that some donors donate many times a year. Therefore we can’t just count the donations.
Donor loyalty.pbix (405.1 KB)