Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

default value to be max(date) automatically selected

hi team, execution date changes every day, i need slicer to have always max(date) for that table automatically selected, please suggest some solution
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

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.