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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
imocean
Frequent Visitor

How to retrieve the selected date range from relative date filter or date slicer

Hello everyone, my first question here hopefully a very basic one for many! 

I have a date filter in my report (in the relative mode so it's like 'last 3 months' etc.). Is there a way to retreive what's been selected in the filter in a measure so I can use it to do some calculations such as sales target etc.? I tried the formula below but it doesn't take the filter at all, instead it just gives me the total number of months in Date table regardless. 

 

SelectedNumberMonths = DATEDIFF(CALCULATE(MIN('Date'[Date]),ALLSELECTED('Date'[Date])), calculate(MAX('Date'[Date]),ALLSELECTED('Date'[Date])), Month)

 

And Date table is a table created to read calendar between 1/01/2001 and 31/12/2025. 

 

CALENDAR (DATE(2001,1,1), DATE(2025,12,31)
 
Thanks! 
1 REPLY 1
imocean
Frequent Visitor

Sorry for this but looks like working now after I added the slicer another time (rather than using the existing one - a bit weird). I will test further to make sure it's fully working though. Thanks anyway. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.