cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

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?

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
1 ACCEPTED SOLUTION

Accepted Solutions
dedelman_clng New Contributor
New Contributor

Re: Using date slicer to calculate a target dynamically

should be able to use something like

 

MIN( ALLSELECTED ( DateTable[Date] )

 

or

 

FIRSTDATE( ALLSELECTED (DateTable[Date]) )

2 REPLIES 2
dedelman_clng New Contributor
New Contributor

Re: Using date slicer to calculate a target dynamically

should be able to use something like

 

MIN( ALLSELECTED ( DateTable[Date] )

 

or

 

FIRSTDATE( ALLSELECTED (DateTable[Date]) )

Super User
Super User

Re: Using date slicer to calculate a target dynamically

thank you!


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!