Forum Discussion

Rahulsingh's avatar
Rahulsingh
Helper 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.

Bhavana_k's avatar
Bhavana_k
Helper I
4 years ago

Hi There,
I have written the same formula to get the min & max value from the date slicer but for some reason it's not working for me.

Here is the formula to get slicer start & end date

startDate = CALCULATE(MIN('CASE_DEFLECTION_ANALYSIS'[SYS_CREATED_ON].[Date]), ALLSELECTED('CASE_DEFLECTION_ANALYSIS'))

endDate = CALCULATE(MAX(CASE_DEFLECTION_ANALYSIS[SYS_CREATED_ON].[Date]), ALLSELECTED(CASE_DEFLECTION_ANALYSIS))


Is there something I need to do in the desktop settings? 

Hemanth96's avatar
Hemanth96
Frequent Visitor
3 years ago

Try Removing .[Date] and it should work.
Updated DAX

 

startDate = CALCULATE(MIN('CASE_DEFLECTION_ANALYSIS'[SYS_CREATED_ON]), ALLSELECTED('CASE_DEFLECTION_ANALYSIS'))

endDate = CALCULATE(MAX(CASE_DEFLECTION_ANALYSIS[SYS_CREATED_ON]), ALLSELECTED(CASE_DEFLECTION_ANALYSIS))


 

Please give a Thumbs-up if it worked