Issue with year to date comparisons

Hi MvdBlom, 

You could try to upload your sample on OneDrive or other place I could access it, then I will help you more correctly. By the way, you could try to use simple data sample to repalce your real data, and inform me your expected output.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.