TYD total minus current week

[Anonymous]

What I feel should be easy has me stumped this morning I am tying to create a simple YTD calculation of "Item Total New" for the current year but with an end date being the last day of the previous week. I have the fact table joined to a date table that has a lastdayofweek column. I pulled in the values using a slicer as shown in the top chart for validation purposes and the second table is using my measure shown at the top of screen. I am able to get the YTD easily but its giving me total through today. Any help would be greatly appreciated. 

[some_bih · Accepted solution]

Hi @Anonymous as you want control dates / weeks what will be visible / calculated you need "appropriate flag" up to / after certain day / week. Check link below, part as named. Hope this help / kudos appreciated.

https://www.daxpatterns.com/week-related-calculations/ 

Controlling the visualization in future dates and 

Introduction to week-related time intelligence calculations