topic How to get Mom, QoQ and YoY% calculation change in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-Mom-QoQ-and-YoY-calculation-change/m-p/3152323#M112958 <P>Hi All,<BR /><BR />I have a question on how to calculate&nbsp;Mom, QoQ and YoY% change and then use it on line and clustered column chart. My data somewhat looks like this. So, for 2022 Mar to 2022 April the sales got increased from 7891 to 9623, I need that to show as MoM percentage growth and similarly for the rest.<BR />Can anybody please help me with this?<BR /><BR /></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Year</TD><TD>Quarter</TD><TD>Month</TD><TD>size</TD></TR><TR><TD>2022</TD><TD>Qtr 1</TD><TD>March</TD><TD>7891,78</TD></TR><TR><TD>2022</TD><TD>Qtr 2</TD><TD>April</TD><TD>9623,21</TD></TR><TR><TD>2022</TD><TD>Qtr 2</TD><TD>May</TD><TD>6853,63</TD></TR><TR><TD>2022</TD><TD>Qtr 2</TD><TD>June</TD><TD>1528978</TD></TR><TR><TD>2022</TD><TD>Qtr 3</TD><TD>July</TD><TD>195737,1</TD></TR><TR><TD>2022</TD><TD>Qtr 3</TD><TD>August</TD><TD>168077,9</TD></TR><TR><TD>2022</TD><TD>Qtr 3</TD><TD>September</TD><TD>294695,8</TD></TR><TR><TD>2022</TD><TD>Qtr 4</TD><TD>October</TD><TD>23159,34</TD></TR><TR><TD>2022</TD><TD>Qtr 4</TD><TD>November</TD><TD>214343</TD></TR><TR><TD>2022</TD><TD>Qtr 4</TD><TD>December</TD><TD>42684,12</TD></TR><TR><TD>2023</TD><TD>Qtr 1</TD><TD>January</TD><TD>150256,5</TD></TR><TR><TD>2023</TD><TD>Qtr 1</TD><TD>February</TD><TD>167633,6</TD></TR><TR><TD>2023</TD><TD>Qtr 1</TD><TD>March</TD><TD>167716,5</TD></TR></TBODY></TABLE><P>&nbsp;</P> Fri, 24 Mar 2023 11:55:35 GMT Anonymous 2023-03-24T11:55:35Z How to get Mom, QoQ and YoY% calculation change https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-Mom-QoQ-and-YoY-calculation-change/m-p/3152323#M112958 <P>Hi All,<BR /><BR />I have a question on how to calculate&nbsp;Mom, QoQ and YoY% change and then use it on line and clustered column chart. My data somewhat looks like this. So, for 2022 Mar to 2022 April the sales got increased from 7891 to 9623, I need that to show as MoM percentage growth and similarly for the rest.<BR />Can anybody please help me with this?<BR /><BR /></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Year</TD><TD>Quarter</TD><TD>Month</TD><TD>size</TD></TR><TR><TD>2022</TD><TD>Qtr 1</TD><TD>March</TD><TD>7891,78</TD></TR><TR><TD>2022</TD><TD>Qtr 2</TD><TD>April</TD><TD>9623,21</TD></TR><TR><TD>2022</TD><TD>Qtr 2</TD><TD>May</TD><TD>6853,63</TD></TR><TR><TD>2022</TD><TD>Qtr 2</TD><TD>June</TD><TD>1528978</TD></TR><TR><TD>2022</TD><TD>Qtr 3</TD><TD>July</TD><TD>195737,1</TD></TR><TR><TD>2022</TD><TD>Qtr 3</TD><TD>August</TD><TD>168077,9</TD></TR><TR><TD>2022</TD><TD>Qtr 3</TD><TD>September</TD><TD>294695,8</TD></TR><TR><TD>2022</TD><TD>Qtr 4</TD><TD>October</TD><TD>23159,34</TD></TR><TR><TD>2022</TD><TD>Qtr 4</TD><TD>November</TD><TD>214343</TD></TR><TR><TD>2022</TD><TD>Qtr 4</TD><TD>December</TD><TD>42684,12</TD></TR><TR><TD>2023</TD><TD>Qtr 1</TD><TD>January</TD><TD>150256,5</TD></TR><TR><TD>2023</TD><TD>Qtr 1</TD><TD>February</TD><TD>167633,6</TD></TR><TR><TD>2023</TD><TD>Qtr 1</TD><TD>March</TD><TD>167716,5</TD></TR></TBODY></TABLE><P>&nbsp;</P> Fri, 24 Mar 2023 11:55:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-Mom-QoQ-and-YoY-calculation-change/m-p/3152323#M112958 Anonymous 2023-03-24T11:55:35Z Re: How to get Mom, QoQ and YoY% calculation change https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-Mom-QoQ-and-YoY-calculation-change/m-p/3154746#M113120 <P>Please try some of the Quick Measures that cover these patterns.</P> Sun, 26 Mar 2023 23:24:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-Mom-QoQ-and-YoY-calculation-change/m-p/3154746#M113120 lbendlin 2023-03-26T23:24:24Z