1 of 1 people found this helpful
YOur data "drops off" after 12 months because you have a filter on date set to 12 months - you have filtered out any older data
so what to do?
Remove the filter
Add a Parameter where the user can input a date OR you can use the Max(date) in the data set a date
Then base your 12 month and 24 month calculated fields on the max date or parameter
I'm not a real fan of datediff as a way to go (it will work) I like you use datetrunc combined with dateadd - but then again I have an engineering degree so I look at things a little differently
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Oh my god! It really has been one of those weeks for me! I totally did not think about what was going on. I tried so many different variations with changing the formula and date range but somehow this one passed by me. Thanks very much (although I am super embarrassed!)
Dont be embarrassed - we've all been there -
It is probably in the top 5 questions we see on the forum
Glad to help out