https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/issue-with-snow-schema-when-using-SAMEPERIODLASTYEAR/m-p/2068825#M46788 <P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-p/1626726" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-p/1626726</A></P><P>&nbsp;</P> Fri, 10 Sep 2021 11:40:44 GMT Anonymous 2021-09-10T11:40:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/issue-with-snow-schema-when-using-SAMEPERIODLASTYEAR/m-p/2062278#M46557 <DIV class="s-prose js-post-body"><P>I have a schema with relationships:</P><P><STRONG>Many</STRONG><SPAN>&nbsp;</SPAN>Revenue[ClientKey] :<SPAN>&nbsp;</SPAN><STRONG>1</STRONG><SPAN>&nbsp;</SPAN>Client[ClientKey]</P><P>filter: &lt;&lt; To Revenue</P><P>&nbsp;</P><P><STRONG>Many</STRONG><SPAN>&nbsp;</SPAN>ClientType[ClientNo] :<SPAN>&nbsp;</SPAN><STRONG>1</STRONG><SPAN>&nbsp;</SPAN>Client[ClientNo]</P><P>&nbsp;</P><P><STRONG>Many</STRONG><SPAN>&nbsp;</SPAN>ClientType[Year] :<SPAN>&nbsp;</SPAN><STRONG>Many</STRONG><SPAN>&nbsp;</SPAN>Date[Year]</P><P>&nbsp;</P><P>Not sure how I will use the last 2 relationships in the pbix; but I set the filter to &lt;&lt;"Both tables"&gt;&gt;</P><P>&nbsp;</P><P>I am having issues with basic measures:</P><UL><LI><P>Revenue := YTDCALCULATE([Revenue] ,DATESYTD('Date'[Date] ,"31/05" ))</P></LI><LI><P>Revenue LYTD := CALCULATE( [Revenue YTD],SAMEPERIODLASTYEAR('Date'[Date] ) )</P></LI></UL><P>Revenue displays ok. But Revenue LYTD, displays<SPAN>&nbsp;</SPAN><STRONG>only the total</STRONG><SPAN>&nbsp;</SPAN>in a table visualization. Could the relationship somehow make this?</P></DIV><DIV class="mt24 mb12"><DIV class="post-taglist d-flex gs4 gsy fd-column"><DIV class="d-flex ps-relative">&nbsp;</DIV></DIV></DIV> Tue, 07 Sep 2021 16:12:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/issue-with-snow-schema-when-using-SAMEPERIODLASTYEAR/m-p/2062278#M46557 Anonymous 2021-09-07T16:12:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/issue-with-snow-schema-when-using-SAMEPERIODLASTYEAR/m-p/2068825#M46788 <P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-p/1626726" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-p/1626726</A></P><P>&nbsp;</P> Fri, 10 Sep 2021 11:40:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/issue-with-snow-schema-when-using-SAMEPERIODLASTYEAR/m-p/2068825#M46788 Anonymous 2021-09-10T11:40:44Z