default value to be max(date) automatically selected

[Anonymous]

hi team,

execution date changes every day, i need slicer to have always max(date) for that table automatically selected, please suggest some solution

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Some ideas,

(1) use relative date,

(2) use an auxiliary table

Start = MINX(ALLSELECTED('DATE'),'DATE'[Date])

End = 
var _end= MAXX(ALLSELECTED('DATE'),'DATE'[Date])
return IF(SELECTEDVALUE('Table'[Value])="DATE", _end,TODAY())

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.