Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!  
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

thanks for your reply. unfortunately it didnt work...I'm still seeing the same thing

 

mwegener's avatar
mwegener
Most Valuable Professional
4 years ago

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.

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    4 years ago

    Anonymous 

     

    If you want to filter, you should use the filter pane. e.g. like this.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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 

     

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      4 years ago

      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.