Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Still not working, as the same error before.;

    IDDateFinancial Year
    1111111January 2009FY9
    12434345Aug 2010FY11
    3432423412 Aug 2009FY10
    1111111January 2010FY10
    351241February 1978FY78
    6834347February 1978FY78
    1111111January 2009FY9
    12434545August 2009FY9

     

    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.