Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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 -
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?
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
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.