https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TYD-total-minus-current-week/m-p/3409192#M128840 <P>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.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 31 Aug 2023 14:59:17 GMT Anonymous 2023-08-31T14:59:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TYD-total-minus-current-week/m-p/3409192#M128840 <P>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.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 31 Aug 2023 14:59:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TYD-total-minus-current-week/m-p/3409192#M128840 Anonymous 2023-08-31T14:59:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TYD-total-minus-current-week/m-p/3409693#M128862 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;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.</P><H2><A href="https://www.daxpatterns.com/week-related-calculations/" target="_self">https://www.daxpatterns.com/week-related-calculations/</A>&nbsp;</H2><H2>Controlling the visualization in future dates and&nbsp;</H2><H1>Introduction to week-related time intelligence calculations</H1> Thu, 31 Aug 2023 20:06:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TYD-total-minus-current-week/m-p/3409693#M128862 some_bih 2023-08-31T20:06:49Z