Why does MAX(DATE) return multiple values?

[Anonymous]

'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!

[v-xiaotang]

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.

[mwegener]

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]

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

[mwegener]

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.

[Anonymous]

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]

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

[mwegener]

@Anonymous 

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