Forum Discussion
Why does MAX(DATE) return multiple values?
'Date_0' is type date and has dates till 2021-12-31. However, Max(Date) returns all dates from 2021 in stead of 2021-12-31. Could someboday please help on this? Thanks in advance!
It has nothing to do with filter. My screenshot shows the formula i put in and the table shows the result i got. If this helps, please see the below sc
Anonymous ,
there are a few things we need to consider here.
1. Why are you using a calculated column and not a masure?
2. Why have you activated the Auto Date/Time function?
Currently, you could simply switch the display from the built-in Date Hierarchy to the value of the column.