Forum Discussion
Getting upper date value in a slicer
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!
4 Replies
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
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). 😋
On a slicer date I typically able to get date
Date= MAXX (MyDateTable,ALLSELECTED ( MyDateTable[Date] ) )
