How can i get latest date in a date column where the data is from 01-01-2022 to 31-01-2022 so here the latest date is 31-01-2022

Latest Date Calculation

Hi,
you can use the Max function but be sure the field data type should be date not the string.

Most of the people do this common mistake. :slight_smile:

Regards,

1 Like

Also, Make sure when you are using max() to get maximum date from your column , put in measure, it will not get identified in dimensions.