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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 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.