Skip to main content
cancel
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

Reply
E__
Helper III
Helper III

Relative date relative to a selected max date instead of today

Hi,

 

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,

Best,

Eva

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

2 REPLIES 2
v-lionel-msft
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

v-lionel-msft_0-1596422934118.png

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.

 

 

 

amitchandak
Super User
Super User

@E__ , No possible as of now.

 

Try this https://www.youtube.com/watch?v=duMSovyosXE

 

vote for idea

Relative Date Slicer with Date
https://ideas.powerbi.com/ideas/idea/?ideaid=37cf4112-bb85-44fe-ba0d-188517c39a2b -planned

Helpful resources

Announcements
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.