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!
Hi Anonymous ,
I'm not sure what you're trying to accomplish.
In your screenshot I see a table with year, quarter, month and day and the DAX formula for the Latest_Date calculation.
You do realize that the DAX formula is not a filter for the visual, but only a calculation that can then be output in a visual.
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.