https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-For-SamePeriodLastYear/m-p/672422#M370 <P>I have one Date Table, one table [Active Contracts] with distinct ContractNumber as PrimaryKey, and four other tables which has ContractNumber as Foreign Key and has Date on each of four tables and I have also created Many to One relationship. I am using ContractNumber and Date as Filter.</P><P>All the calculation works but the sameperiodLastyear.&nbsp;</P><P>My Recent Year Total DAX looks like&nbsp; RecentYearRevenue= sum(BaseAmount) + sum(OverageAmount), for the date Range selected. So my Previous Year Total DAX looks like&nbsp;</P><DIV><DIV><SPAN>Previous Year Revenue= CALCULATE( RecentYearRevenue,SAMEPERIODLASTYEAR('Date'[Date])).</SPAN></DIV><DIV><SPAN>it works for all contracts, but when I filter it by contract number, PreviousYearRevenue is returning BLANK. </SPAN></DIV><DIV><SPAN>Your help will be highly appriciated. Thank you in Advance!</SPAN></DIV></DIV> Wed, 17 Apr 2019 20:15:22 GMT kedarn1991 2019-04-17T20:15:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-For-SamePeriodLastYear/m-p/672422#M370 <P>I have one Date Table, one table [Active Contracts] with distinct ContractNumber as PrimaryKey, and four other tables which has ContractNumber as Foreign Key and has Date on each of four tables and I have also created Many to One relationship. I am using ContractNumber and Date as Filter.</P><P>All the calculation works but the sameperiodLastyear.&nbsp;</P><P>My Recent Year Total DAX looks like&nbsp; RecentYearRevenue= sum(BaseAmount) + sum(OverageAmount), for the date Range selected. So my Previous Year Total DAX looks like&nbsp;</P><DIV><DIV><SPAN>Previous Year Revenue= CALCULATE( RecentYearRevenue,SAMEPERIODLASTYEAR('Date'[Date])).</SPAN></DIV><DIV><SPAN>it works for all contracts, but when I filter it by contract number, PreviousYearRevenue is returning BLANK. </SPAN></DIV><DIV><SPAN>Your help will be highly appriciated. Thank you in Advance!</SPAN></DIV></DIV> Wed, 17 Apr 2019 20:15:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-For-SamePeriodLastYear/m-p/672422#M370 kedarn1991 2019-04-17T20:15:22Z