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
mwegener's avatar
mwegener
Most Valuable Professional
4 years ago

Hi Anonymous ,

 

I think this has to do with your filter context.

If you always want to have the last one, the following formula might help.

Latest_Date = MAXX(ALL(raw[Date_0]), raw[Date_0])

 

 

  • 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.