topic YTD &amp; YTG calculation with new header in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-amp-YTG-calculation-with-new-header/m-p/3240185#M119194 <P>I am trying to calculate YTG and&nbsp; YTD calculation&nbsp; like new header&nbsp; 2022-2021 ,2023-2022,2024-2023,2025-2024.I have posted sample Data for reference&nbsp;</P><P>&nbsp;</P><P><STRONG>(previousyear -Currentyear)/Currentyear</STRONG></P><P>&nbsp;</P><P>Region&nbsp; &nbsp; &nbsp; Date&nbsp; &nbsp; &nbsp; &nbsp; -&nbsp; &nbsp; Year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Value&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2021&nbsp; &nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 250</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2022&nbsp; &nbsp; &nbsp; &nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 350</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2023&nbsp; &nbsp; &nbsp; &nbsp;2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 420</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2024&nbsp; &nbsp; &nbsp; &nbsp;2024&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 460</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2025&nbsp; &nbsp; &nbsp; &nbsp;2025&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 440</P><P>&nbsp;</P><P>Expected Output :&nbsp; &nbsp; &nbsp; &nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '</P><P>2022-2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40%</P><P>2023-2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -17%</P><P>2024-2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-9%</P><P>2025-2024&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5%</P><P>&nbsp;I want to show above result in the Group .</P><P>&nbsp;</P><P>Looking for support . thanks in&nbsp; advance</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 17 May 2023 12:41:22 GMT Anonymous 2023-05-17T12:41:22Z YTD & YTG calculation with new header https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-amp-YTG-calculation-with-new-header/m-p/3240185#M119194 <P>I am trying to calculate YTG and&nbsp; YTD calculation&nbsp; like new header&nbsp; 2022-2021 ,2023-2022,2024-2023,2025-2024.I have posted sample Data for reference&nbsp;</P><P>&nbsp;</P><P><STRONG>(previousyear -Currentyear)/Currentyear</STRONG></P><P>&nbsp;</P><P>Region&nbsp; &nbsp; &nbsp; Date&nbsp; &nbsp; &nbsp; &nbsp; -&nbsp; &nbsp; Year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Value&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2021&nbsp; &nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 250</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2022&nbsp; &nbsp; &nbsp; &nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 350</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2023&nbsp; &nbsp; &nbsp; &nbsp;2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 420</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2024&nbsp; &nbsp; &nbsp; &nbsp;2024&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 460</P><P>west&nbsp; &nbsp; &nbsp; &nbsp; Jan-2025&nbsp; &nbsp; &nbsp; &nbsp;2025&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 440</P><P>&nbsp;</P><P>Expected Output :&nbsp; &nbsp; &nbsp; &nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '</P><P>2022-2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40%</P><P>2023-2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -17%</P><P>2024-2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-9%</P><P>2025-2024&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5%</P><P>&nbsp;I want to show above result in the Group .</P><P>&nbsp;</P><P>Looking for support . thanks in&nbsp; advance</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 17 May 2023 12:41:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-amp-YTG-calculation-with-new-header/m-p/3240185#M119194 Anonymous 2023-05-17T12:41:22Z Re: YTD & YTG calculation with new header https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-amp-YTG-calculation-with-new-header/m-p/3240536#M119211 <P>Anonymous</LI-USER> , You have to create a new column </P> <P>&nbsp;</P> <P>Year name = [Year] &amp; "-" &amp;[Year] -1</P> <P>&nbsp;</P> <P>and measure like diff % can be used</P> <P>&nbsp;</P> <P>//Only year vs Year, not a level below</P> <P>This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))<BR />Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))<BR />diff = [This Year]-[Last Year ]<BR />diff % = divide([This Year]-[Last Year ],[Last Year ])</P> Wed, 17 May 2023 15:13:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-amp-YTG-calculation-with-new-header/m-p/3240536#M119211 amitchandak 2023-05-17T15:13:01Z Re: YTD & YTG calculation with new header https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-amp-YTG-calculation-with-new-header/m-p/3241522#M119279 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>&nbsp; created the column&nbsp; when i was apply the column its not showing the value .&nbsp; when i use orignal column use its showing the value&nbsp;</P> Thu, 18 May 2023 04:59:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YTD-amp-YTG-calculation-with-new-header/m-p/3241522#M119279 Anonymous 2023-05-18T04:59:15Z