cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors