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...
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]) )

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]) )

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    thank you!