cancel
Showing results for 
Search instead for 
Did you mean: 
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 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
amitchandak
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors