Measure based on relative date (belongs to this week)

[JMS1985]

Hello,

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

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!

[amitchandak · Accepted solution]

@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