MAX does not return the correct value

[lcasey]

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?

[nickchobotar]

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

[lcasey]

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?

[v-shex-msft]

Hi @lcasey,

If you have any other filters apply on current table, you can user allselected function with table name to apply all filters effect.

maxDate = LASTDATE(ALLSELECTED('Calendar'))

Regards,

Xiaoxin Sheng

[lcasey]

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.