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

7 Replies

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

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Anonymous 

    I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

    If you need more help, please let me know.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.