Forum Discussion

Rahulsingh's avatar
Rahulsingh
Icon for Helper I rankHelper I
8 years ago
Solved

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 greatl...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Rahulsingh,

     

    Use this formula: 

     

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

     

    Regards.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Perhaps something like:

 

MyDate = MAX(Table[DateRec])
Rahulsingh's avatar
Rahulsingh
Icon for Helper I rankHelper I
8 years ago

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.