https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-and-year-Separate-column-compare-current-and-previous-year/m-p/2094753#M47732 <P>&nbsp; my data set like below we have enter the March&nbsp; Month value in&nbsp; &nbsp;Apirl and April&nbsp; Month&nbsp; value enter May month like below&nbsp;</P><P>Month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Period&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Values&nbsp;</P><P>March&nbsp; &nbsp; &nbsp; &nbsp; 01-04-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45<BR />April&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-05-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23<BR />May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-06-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23</P><P>...</P><P>....</P><P>...</P><P>August&nbsp; &nbsp; &nbsp; 01-09-2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23</P><P>Sep&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15-09-2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P><P>&nbsp;</P><P>last upto now entered value&nbsp; sep 15 data . how to current year (2021 ) compare to previous year (2020) based Month and year (period)&nbsp; any idea ..thanks in advance .&nbsp;</P> Thu, 23 Sep 2021 14:47:53 GMT Anonymous 2021-09-23T14:47:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-and-year-Separate-column-compare-current-and-previous-year/m-p/2094753#M47732 <P>&nbsp; my data set like below we have enter the March&nbsp; Month value in&nbsp; &nbsp;Apirl and April&nbsp; Month&nbsp; value enter May month like below&nbsp;</P><P>Month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Period&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Values&nbsp;</P><P>March&nbsp; &nbsp; &nbsp; &nbsp; 01-04-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45<BR />April&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-05-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23<BR />May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-06-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23</P><P>...</P><P>....</P><P>...</P><P>August&nbsp; &nbsp; &nbsp; 01-09-2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23</P><P>Sep&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15-09-2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P><P>&nbsp;</P><P>last upto now entered value&nbsp; sep 15 data . how to current year (2021 ) compare to previous year (2020) based Month and year (period)&nbsp; any idea ..thanks in advance .&nbsp;</P> Thu, 23 Sep 2021 14:47:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-and-year-Separate-column-compare-current-and-previous-year/m-p/2094753#M47732 Anonymous 2021-09-23T14:47:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-and-year-Separate-column-compare-current-and-previous-year/m-p/2095657#M47767 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P><P>&nbsp;</P><P>You can use&nbsp;<A href="https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax" target="_self">SAMEPERIODLASTYEAR</A> in your measure to find the value in the same month last year.</P><P>&nbsp;</P><P><FONT face="helvetica"><SPAN>If this post&nbsp;</SPAN><STRONG>helps</STRONG><SPAN>, please consider&nbsp;<STRONG>accepting</STRONG></SPAN><STRONG><EM>&nbsp;it as the solution<SPAN>&nbsp;</SPAN></EM></STRONG><SPAN>to help the other members find it more quickly.</SPAN></FONT></P><P><FONT face="helvetica"><SPAN><STRONG>Appreciate your Kudos<span class="lia-unicode-emoji" title=":victory_hand:">✌️</span></STRONG>!!</SPAN></FONT></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 24 Sep 2021 00:56:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Month-and-year-Separate-column-compare-current-and-previous-year/m-p/2095657#M47767 VahidDM 2021-09-24T00:56:05Z