How to get value from date slicer

---

Anonymous wrote:

Hi Rahulsingh,

 

Use this formula: 

 

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

 

Regards.

---

This is pretty close but doesn't completely work.

Example: If you have a from and through date of 10/1/2018 to 12/31/2018 but you only have data that goes up to 12/15/2018, this will result in the max date being 12/15/2018 not 12/31/2018. If you wanted to use 12/31/2018 in a calcluation you couldn't.

Is there any way to just grab the date a user enters and use that date in another calculation, regardless of the data set that is returned?

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?