https://community.fabric.microsoft.com/t5/Developer/Calculate-year-level-measure/m-p/301566#M8863 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="46479" data-lia-user-login="AshokkumarM" class="lia-mention lia-mention-user">AshokkumarM</a></P> <P>You may need a calendar table and measures as below.</P> <PRE>currentYearSales = CALCULATE(SUM(yourTable[sales]),ALLEXCEPT('calendar','calendar'[Date].[Year])) lastYearSales = CALCULATE(SUM(yourTable[sales]),FILTER(ALL('calendar'),'calendar'[Date].[Year]=MAX('calendar'[Date].[Year])-1))</PRE> <P>&nbsp;</P> <P>&nbsp;&nbsp;</P> <P>See more details in the attached pbix file.</P> Tue, 21 Nov 2017 08:40:31 GMT Eric_Zhang 2017-11-21T08:40:31Z https://community.fabric.microsoft.com/t5/Developer/Calculate-year-level-measure/m-p/300909#M8852 <P>Hi,</P><P>&nbsp;</P><P>&nbsp; &nbsp; My requirement is get to full year total of selected month or each month like below report, Could anyone help in achieving this.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thanks,</P><P>Ashok Kumar M</P> Fri, 10 Nov 2017 13:43:16 GMT https://community.fabric.microsoft.com/t5/Developer/Calculate-year-level-measure/m-p/300909#M8852 AshokkumarM 2017-11-10T13:43:16Z https://community.fabric.microsoft.com/t5/Developer/Calculate-year-level-measure/m-p/301566#M8863 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="46479" data-lia-user-login="AshokkumarM" class="lia-mention lia-mention-user">AshokkumarM</a></P> <P>You may need a calendar table and measures as below.</P> <PRE>currentYearSales = CALCULATE(SUM(yourTable[sales]),ALLEXCEPT('calendar','calendar'[Date].[Year])) lastYearSales = CALCULATE(SUM(yourTable[sales]),FILTER(ALL('calendar'),'calendar'[Date].[Year]=MAX('calendar'[Date].[Year])-1))</PRE> <P>&nbsp;</P> <P>&nbsp;&nbsp;</P> <P>See more details in the attached pbix file.</P> Tue, 21 Nov 2017 08:40:31 GMT https://community.fabric.microsoft.com/t5/Developer/Calculate-year-level-measure/m-p/301566#M8863 Eric_Zhang 2017-11-21T08:40:31Z