Forum Discussion
Continuous Years
Hello, I have created the below measure to calcuate continuous years of giving. VAR __Previous = MAXX(FILTER('Gifts (2)','Gifts (2)'[constituent_id] = EARLIER('Gifts (2)'[constituent_id]) && [F...
Anonymous , try this change
AR __Previous = MAXX(FILTER(allselected('Gifts (2)'),'Gifts (2)'[constituent_id] = max('Gifts (2)'[constituent_id]) && [Financial Year] < max('Gifts (2)'[Financial Year])),'Gifts (2)'[Financial Year])
RETURN [Financial Year] - __Previous
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Still not working, as the same error before.;
| ID | Date | Financial Year |
| 1111111 | January 2009 | FY9 |
| 12434345 | Aug 2010 | FY11 |
| 34324234 | 12 Aug 2009 | FY10 |
| 1111111 | January 2010 | FY10 |
| 351241 | February 1978 | FY78 |
| 6834347 | February 1978 | FY78 |
| 1111111 | January 2009 | FY9 |
| 12434545 | August 2009 | FY9 |
I'm wanting the FY9 to be displayed as FY09 and I am wanting to know the continuous years of gifting based on ID across Financial Years, they have to be continuous give across financial years to be classed as continuous donors. For instance, an ID that has gifted for FY 78, 79 and 80 would be 3 years of conitiunous donating.