https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-Last-year/m-p/3288017#M122307 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="420267" data-lia-user-login="Talal141218" class="lia-mention lia-mention-user">Talal141218</a>&nbsp;</P> <P>please try</P> <P>YTD LY =<BR />CALCULATE (<BR />[Measure],<BR />FILTER (<BR />SAMEPERIODLASTYEAR ( 'Date'[Date] ),<BR />VALUE ( FORMAT ( [Date], "mmdd" ) ) &lt;= VALUE ( FORMAT ( TODAY (), "mmdd" ) )<BR />)<BR />)</P> Fri, 16 Jun 2023 14:05:45 GMT tamerj1 2023-06-16T14:05:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-Last-year/m-p/3287999#M122303 <P>&nbsp;Hi everyone,&nbsp;</P><P>I want to create a measure to select throgh it YTD for last year and i tryed but as below :&nbsp;</P><P>=calculate( YTD, sameperiodlastyear(date))., but i did't got a result.&nbsp;</P><P>&nbsp;</P><P>Could you please support me to create a correct m,easure.&nbsp;</P><P>Thanks in advace&nbsp;</P> Fri, 16 Jun 2023 13:54:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-Last-year/m-p/3287999#M122303 Talal141218 2023-06-16T13:54:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-Last-year/m-p/3288017#M122307 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="420267" data-lia-user-login="Talal141218" class="lia-mention lia-mention-user">Talal141218</a>&nbsp;</P> <P>please try</P> <P>YTD LY =<BR />CALCULATE (<BR />[Measure],<BR />FILTER (<BR />SAMEPERIODLASTYEAR ( 'Date'[Date] ),<BR />VALUE ( FORMAT ( [Date], "mmdd" ) ) &lt;= VALUE ( FORMAT ( TODAY (), "mmdd" ) )<BR />)<BR />)</P> Fri, 16 Jun 2023 14:05:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-Last-year/m-p/3288017#M122307 tamerj1 2023-06-16T14:05:45Z