DAX: Why is LastDate not working?

[Anonymous]

[Anonymous]

HI @Anonymous 

  THis is because your column has duplicate dates. To avoid this, if you have Date table you can use the date from that date table, which wil be unique and solve the issue.

Thanks
Raj

[Anonymous · Accepted solution]

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.

[Anonymous]

Thats correct. Glad that you fixed it!