DAX: Why is LastDate not working?

Thanks so much for your reply! I just figured it out

That wasn't the reason. The column was formatted as datetime so I needed to specify .date and it works perfectly. The "Distinct" filter would have fixed the dupilicate columns if that was the issue I think.