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.

1 Reply

  • 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.