Forum Discussion

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago
Solved

Using date slicer to calculate a target dynamically

is there a way of passing  or grabbing the first date in a date slicer to a calculation?  

 

i want to calculated a target based on whether i am looking at this years data or last year data.   Just wondering if there is a dynamic way to do this?

 

Need Help
  • dedelman_clng's avatar
    dedelman_clng
    9 years ago

    should be able to use something like

     

    MIN( ALLSELECTED ( DateTable[Date] )

     

    or

     

    FIRSTDATE( ALLSELECTED (DateTable[Date]) )

2 Replies

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    9 years ago

    should be able to use something like

     

    MIN( ALLSELECTED ( DateTable[Date] )

     

    or

     

    FIRSTDATE( ALLSELECTED (DateTable[Date]) )