Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Lapsed Donors Calculated Column

Hi,   This is my first post but I have been using the forum for reaserch for a few years now.   My dataset is made of Donations data and I am trying to create a column which has either "Lapsed" o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

Thanks for coming back to me so quickly and explaining it clearly.

I have created the column but unfortunately it isn't quite working right as there is no lapsed donors. Below is a screen shot with the data set including the latest Payment date, so I can only assume the MAX Payment date element isn't pulling the latest date, I had this issue before when trying something similar. 

 

*Lapsed Donors = IF (DATEDIFF(MAX('Charity Income Summary'[Payment date]),TODAY(),MONTH)>12,"Lapsed","Not Lapsed")

 

The Payment date is linked to a date table if that might affect it?

 

 

Thanks


Chris