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

Question & Answer
,
1

Latest Date Calculation

2

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
3

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.