MAX does not return the correct value

Hello ,

Does anyone know what formula I would need to use to always get the MAX date from a selection in a calander table?

I have a date slicer that users can choose dates between a range. I want a field that will get the max dat of that selection.

My formula is this:  MAX('Calendar'[Date])

But that always returns the same exact date which is the last date in the calendar table. If a user selects a different date, I need thhe formula to use the last date of the calendar table.

Hello,

How come the MAX formula does not work in Power BI?

When I use:  maxDate = LASTDATE(ALLSELECTED('Calendar'[Date]))
 

when a user changes the claendar slicer to another date teh maxDate is still the same exact date without changing to what the user selected.

Is there a way to have the maxDate change to the last date of the calendar selection made by the end user?

lcasey

You sure can.  You got the two options below:

= LASTDATE ( 'Date'[Date] )

You can still use ALLSELECTED, but only as CALCULATE simple filter argument. =
CALCULATE ( 
    LASTDATE ( 'Date'[Date] ),
    ALLSELECTED () 
)

N -