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.