How to get the Maximum date from the Dynamic Date slicer which would be further used as a filter for

[Anonymous · Accepted solution]

Hi @Anonymous ,

If there's no other condition, you could simple use MAX('table'[date]) to get the maximum date.

If there are other conditions, you could use below formula:

max_date = CALCULATE(MAX('table'[date]),FILTER(ALLSELECTED('table'),condition))

Best Regards,

Jay

[amitchandak]

@Anonymous ,

example how to get dates min/max

new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))