Getting upper date value in a slicer

[AMS_Pag]

Hi,

I have a date slicer which filters the data based on two dates. 
I wanted to get the upper value selected in the slicer but I've not been able to get it.

I tried this formula, picking it from previous messages on Power BI Community but it doesn't work:

CALCULATE ( MAX ( MyDateTable[Date] ), ALLSELECTED ( MyDateTable[Date] ) )

Can you help me?

Thanks! 

[Pragati11]

Hi @AMS_Pag ,

Have you tried using Relative date slicer in this scenario? There is similar thread for this:

https://community.powerbi.com/t5/Desktop/Default-upper-value-for-date-slicer/m-p/876220

Kindly give kudos if this is helpful or aceept this as a solution if it works! 🙂

Thanks,

Pragati

[AMS_Pag]

Yes, I tried it, but also after setting the relative filtering I can't get the "upper" date.

I need to get the upper date dynamically, as it is changed (e.g. if the upper date is changed I need to get the new value, obviously). 😋

[amitchandak]

On a slicer date I typically able to get date

Date= MAXX (MyDateTable,ALLSELECTED ( MyDateTable[Date] ) )

[AMS_Pag]

Unfortunately this DAX returns a compilation error... 😞

Do you have other suggestions?