Forum Discussion
Post PartisanAverages only for latest
Maybe try making a conditional column that returns the latest resolved date for that particular case number across all instances of that case number in the table (forget the whole syntax you'd probably need to wrap the max statement you had in an allexcept on your case column), then compare it to the resolved date in each particular row - that'll flag those which aren't the latest on that case, which you can then filter on to make your calculations right?
Solution SageMaybe try making a conditional column that returns the latest resolved date for that particular case number across all instances of that case number in the table (forget the whole syntax you'd probably need to wrap the max statement you had in an allexcept on your case column), then compare it to the resolved date in each particular row - that'll flag those which aren't the latest on that case, which you can then filter on to make your calculations right?