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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper III
Helper III

Relative date relative to a selected max date instead of today



I want to make in report in which an end user can select a month from the date table, and based on that selection I want to filter dates in my entire report between that max date and the date 12 months before it. Is there a way to do this that doesn't involve explicitly defining the range in all measures used?


I also want to visualise tables in each of which a measure is combined with a field containing "month name year", and I want to show only those 12 months before the selected date, making it very cumbersome/impossible to define everything in measures. 


Is there a way to do this? 


Much appreciated,



Super User
Super User

Community Support
Community Support

Hi @E__ ,


You have the following two requirements:

1. Don't use measures.

2. Relative date relative to a selected max date instead of today


If you want to meet the above two requirements, your idea can not be realized.

The only way is to use measures to realize your ideas, you can refer to @amitchandak 's link.


Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.




Super User
Super User

@E__ , No possible as of now.


Try this


vote for idea

Relative Date Slicer with Date -planned

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.