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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JMS1985
Frequent Visitor

Measure based on relative date (belongs to this week)

Hello,

 

I´ve made a graphic based on a relative date:

JMS1985_0-1605688352447.png

Here I display the current week and the volumes I need to achieve for the following weeks.

For each week of the year I have an objective for the following weeks and I always want to show the objective of todays current week for the current week and the 11 following.

 

However I need to add another column which shouldnt be filtered by this relative date.

 

I´ve tried to make a measure but I cant get it right. 

 

Thanks!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@JMS1985 , are you able to use a relative date slicer? That would be the best. If not. Refer to my blog for a week and rolling weeks and follow the video on how to get more dates/week when you select one

 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

 

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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@JMS1985 , are you able to use a relative date slicer? That would be the best. If not. Refer to my blog for a week and rolling weeks and follow the video on how to get more dates/week when you select one

 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors