Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
AMS_Pag
Frequent Visitor

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 4
Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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] ) )
Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Unfortunately this DAX returns a compilation error... 😞

 

Do you have other suggestions?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.