I have a sample dataset available with me, which is as below :
enter image description here
When I try to create a window on the top of on the basis of the PolicyHolder Id column and try to apply the max(Paid To Date) , I am getting the below result.
enter image description here
Can you let me know why is this giving different dates for A, B and C for all records ? Shouldn’t it be “2020-02-15” for all the records of A ?
Also, When I try to find the Min(Paid From Date), it is giving me the correct answer.
enter image description here