cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rahulsingh Regular Visitor
Regular Visitor

How to get value from date slicer

Hi Everyone, 

 

I am trying to get the date out of this slicer to use it in a formula.  How can I get 3/31/2018 from a slicer in order to pass it to the calculated column?

Any help would be greatly appreciated

Any help would be greatly appreciated Slicer.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: How to get value from date slicer

Hi @Rahulsingh,

 

Use this formula: 

 

Date_Selected = CALCULATE(MAX(Date_Table[DateRec]);ALLSELECTED(Date_Table))

 

Regards.

3 REPLIES 3
Super User
Super User

Re: How to get value from date slicer

Perhaps something like:

 

MyDate = MAX(Table[DateRec])

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Rahulsingh Regular Visitor
Regular Visitor

Re: How to get value from date slicer

hi Greg, 

 

I have used this logic but it gives me the max date of that column which is 5/7/2018 and completely ignores the selection. 

Anonymous
Not applicable

Re: How to get value from date slicer

Hi @Rahulsingh,

 

Use this formula: 

 

Date_Selected = CALCULATE(MAX(Date_Table[DateRec]);ALLSELECTED(Date_Table))

 

Regards.