topic Re: How To create Dax CAGR Dax and FY wise sales and Qtr wise and Growth over last year in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2108882#M48231 <P>Hi all Please help to regarding&nbsp; CAGR DAX&nbsp;</P> Thu, 30 Sep 2021 18:34:08 GMT shri0025 2021-09-30T18:34:08Z How To create Dax CAGR Dax and FY wise sales and Qtr wise and Growth over last year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2107933#M48186 <P>Hi&nbsp; i am new in power BI i need&nbsp; help to Dax&nbsp; . how to create&nbsp; dax&nbsp; CAGR calculation&nbsp; and&nbsp; FY wise&nbsp; and QTR wise and Growth over last year&nbsp; please Help&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Year</TD><TD>Month</TD><TD>Date</TD><TD>FY</TD><TD>Qtr</TD><TD>Region</TD><TD>Type</TD><TD>Division</TD><TD>Sale</TD></TR><TR><TD>2018</TD><TD>April</TD><TD>01-04-2018</TD><TD>FY 2018-19</TD><TD>Q1</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2CC</TD><TD>3387420</TD></TR><TR><TD>2018</TD><TD>May</TD><TD>01-05-2018</TD><TD>FY 2018-19</TD><TD>Q1</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>3L</TD><TD>8965200</TD></TR><TR><TD>2018</TD><TD>June</TD><TD>01-06-2018</TD><TD>FY 2018-19</TD><TD>Q1</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2U</TD><TD>11540940</TD></TR><TR><TD>2018</TD><TD>July</TD><TD>01-07-2018</TD><TD>FY 2018-19</TD><TD>Q2</TD><TD>Central</TD><TD>&nbsp;2C</TD><TD>2C</TD><TD>8771400</TD></TR><TR><TD>2018</TD><TD>August</TD><TD>01-08-2018</TD><TD>FY 2018-19</TD><TD>Q2</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2CC</TD><TD>10638540</TD></TR><TR><TD>2018</TD><TD>September</TD><TD>01-09-2018</TD><TD>FY 2018-19</TD><TD>Q2</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>3L</TD><TD>10788960</TD></TR><TR><TD>2018</TD><TD>October</TD><TD>01-10-2018</TD><TD>FY 2018-19</TD><TD>Q3</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2U</TD><TD>8507160</TD></TR><TR><TD>2018</TD><TD>November</TD><TD>01-11-2018</TD><TD>FY 2018-19</TD><TD>Q3</TD><TD>Central</TD><TD>&nbsp;2C</TD><TD>2C</TD><TD>13713180</TD></TR><TR><TD>2018</TD><TD>December</TD><TD>01-12-2018</TD><TD>FY 2018-19</TD><TD>Q3</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2CC</TD><TD>10863300</TD></TR><TR><TD>2019</TD><TD>January</TD><TD>01-01-2019</TD><TD>FY 2018-19</TD><TD>Q4</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>3L</TD><TD>4907940</TD></TR><TR><TD>2019</TD><TD>February</TD><TD>01-02-2019</TD><TD>FY 2018-19</TD><TD>Q4</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2U</TD><TD>10866540</TD></TR><TR><TD>2019</TD><TD>March</TD><TD>01-03-2019</TD><TD>FY 2018-19</TD><TD>Q4</TD><TD>Central</TD><TD>&nbsp;2C</TD><TD>2C</TD><TD>18677700</TD></TR><TR><TD>2019</TD><TD>April</TD><TD>01-04-2019</TD><TD>FY 2019-20</TD><TD>Q1</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2CC</TD><TD>1053240</TD></TR><TR><TD>2019</TD><TD>May</TD><TD>01-05-2019</TD><TD>FY 2019-20</TD><TD>Q1</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>3L</TD><TD>9638160</TD></TR><TR><TD>2019</TD><TD>June</TD><TD>01-06-2019</TD><TD>FY 2019-20</TD><TD>Q1</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2U</TD><TD>13681680</TD></TR><TR><TD>2019</TD><TD>July</TD><TD>01-07-2019</TD><TD>FY 2019-20</TD><TD>Q2</TD><TD>Central</TD><TD>&nbsp;2C</TD><TD>2C</TD><TD>10381380</TD></TR><TR><TD>2019</TD><TD>August</TD><TD>01-08-2019</TD><TD>FY 2019-20</TD><TD>Q2</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2CC</TD><TD>9399000</TD></TR><TR><TD>2019</TD><TD>September</TD><TD>01-09-2019</TD><TD>FY 2019-20</TD><TD>Q2</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>3L</TD><TD>13274520</TD></TR><TR><TD>2019</TD><TD>October</TD><TD>01-10-2019</TD><TD>FY 2019-20</TD><TD>Q3</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2U</TD><TD>9396660</TD></TR><TR><TD>2019</TD><TD>November</TD><TD>01-11-2019</TD><TD>FY 2019-20</TD><TD>Q3</TD><TD>Central</TD><TD>&nbsp;2C</TD><TD>2C</TD><TD>11214420</TD></TR><TR><TD>2019</TD><TD>December</TD><TD>01-12-2019</TD><TD>FY 2019-20</TD><TD>Q3</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2CC</TD><TD>9107040</TD></TR><TR><TD>2020</TD><TD>January</TD><TD>01-01-2020</TD><TD>FY 2019-20</TD><TD>Q4</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>3L</TD><TD>7627920</TD></TR><TR><TD>2020</TD><TD>February</TD><TD>01-02-2020</TD><TD>FY 2019-20</TD><TD>Q4</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2U</TD><TD>13291560</TD></TR><TR><TD>2020</TD><TD>March</TD><TD>01-03-2020</TD><TD>FY 2019-20</TD><TD>Q4</TD><TD>Central</TD><TD>&nbsp;2C</TD><TD>2C</TD><TD>8464620</TD></TR><TR><TD>2020</TD><TD>May</TD><TD>01-05-2020</TD><TD>FY 2020-21</TD><TD>Q1</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2CC</TD><TD>10495140</TD></TR><TR><TD>2020</TD><TD>June</TD><TD>01-06-2020</TD><TD>FY 2020-21</TD><TD>Q1</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>3L</TD><TD>12128760</TD></TR><TR><TD>2020</TD><TD>July</TD><TD>01-07-2020</TD><TD>FY 2020-21</TD><TD>Q2</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2U</TD><TD>9585960</TD></TR><TR><TD>2020</TD><TD>August</TD><TD>01-08-2020</TD><TD>FY 2020-21</TD><TD>Q2</TD><TD>Central</TD><TD>&nbsp;2C</TD><TD>2C</TD><TD>9261420</TD></TR><TR><TD>2020</TD><TD>September</TD><TD>01-09-2020</TD><TD>FY 2020-21</TD><TD>Q2</TD><TD>Central</TD><TD>&nbsp;2A</TD><TD>2CC</TD><TD>10590780</TD></TR></TBODY></TABLE><P>Out put as below by Dax</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Year</TD><TD>Apr</TD><TD>May</TD><TD>Jun</TD><TD>Q1</TD><TD>Jul</TD><TD>Aug</TD><TD>Sep</TD><TD>Q2</TD><TD>Oct</TD><TD>Nov</TD><TD>Dec</TD><TD>Q3</TD><TD>Jan</TD><TD>Feb</TD><TD>Mar</TD><TD>Q4</TD><TD>Total</TD></TR><TR><TD>2018-19</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.77</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.90</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.30</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 42.97</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15.23</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.27</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18.47</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50.97</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15.45</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.05</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18.88</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51.38</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.83</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16.19</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28.46</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52.49</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 197.81</TD></TR><TR><TD>2019-20</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.26</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.79</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20.12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 41.17</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15.84</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.55</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19.74</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 53.13</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14.32</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15.75</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14.27</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44.34</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13.24</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.66</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.50</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54.40</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 193.04</TD></TR><TR><TD>GOLY</TD><TD>-58%</TD><TD>-1%</TD><TD>16%</TD><TD>-4%</TD><TD>4%</TD><TD>2%</TD><TD>7%</TD><TD>4%</TD><TD>-7%</TD><TD>-8%</TD><TD>-24%</TD><TD>-14%</TD><TD>69%</TD><TD>46%</TD><TD>-39%</TD><TD>4%</TD><TD>-2%</TD></TR><TR><TD>2020-21</TD><TD>0%</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.23</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15.87</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26.10</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.78</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14.16</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16.83</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43.77</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16.98</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.48</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17.66</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52.12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.38</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16.81</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25.13</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54.32</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 176.31</TD></TR><TR><TD>GOLY</TD><TD>-100%</TD><TD>-42%</TD><TD>-21%</TD><TD>-37%</TD><TD>-19%</TD><TD>-19%</TD><TD>-15%</TD><TD>-18%</TD><TD>19%</TD><TD>11%</TD><TD>24%</TD><TD>18%</TD><TD>-6%</TD><TD>-29%</TD><TD>44%</TD><TD>0%</TD><TD>-9%</TD></TR><TR><TD>2021-22</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.88</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.04</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15.43</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23.35</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19.09</TD><TD>0%</TD><TD>0%</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19.09</TD><TD>0%</TD><TD>0%</TD><TD>0%</TD><TD>0%</TD><TD>0%</TD><TD>0%</TD><TD>0%</TD><TD>0%</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 42.45</TD></TR><TR><TD>GOLY</TD><TD>0%</TD><TD>-90%</TD><TD>-3%</TD><TD>-11%</TD><TD>49%</TD><TD>-100%</TD><TD>-100%</TD><TD>-56%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-76%</TD></TR><TR><TD>CAGR</TD><TD>-4%</TD><TD>-61%</TD><TD>-4%</TD><TD>-18%</TD><TD>8%</TD><TD>-100%</TD><TD>-100%</TD><TD>-28%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-100%</TD><TD>-40%</TD></TR></TBODY></TABLE> Thu, 30 Sep 2021 18:36:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2107933#M48186 shri0025 2021-09-30T18:36:35Z Re: How To create Dax CAGR Dax and FY wise sales and Qtr wise and Growth over last year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2108882#M48231 <P>Hi all Please help to regarding&nbsp; CAGR DAX&nbsp;</P> Thu, 30 Sep 2021 18:34:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2108882#M48231 shri0025 2021-09-30T18:34:08Z Re: How To create Dax CAGR Dax and FY wise sales and Qtr wise and Growth over last year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2112030#M48304 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="320137" data-lia-user-login="shri0025" class="lia-mention lia-mention-user">shri0025</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="3856" data-lia-user-login="Mike_Carlo" class="lia-mention lia-mention-user">Mike_Carlo</a>&nbsp;created calculations for this here:&nbsp;<A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Compound-Annual-Growth-Rate/m-p/164550#M8" target="_blank">Compound Annual Growth Rate - Microsoft Power BI Community</A></P> <P>&nbsp;</P> Sat, 02 Oct 2021 17:20:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2112030#M48304 Greg_Deckler 2021-10-02T17:20:37Z Re: How To create Dax CAGR Dax and FY wise sales and Qtr wise and Growth over last year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2112855#M48364 <P class="lia-align-left">Hi Not worked in Month wise CAGR&nbsp;</P><P class="lia-align-left">&nbsp;</P> Mon, 04 Oct 2021 04:37:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2112855#M48364 shri0025 2021-10-04T04:37:41Z Re: How To create Dax CAGR Dax and FY wise sales and Qtr wise and Growth over last year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2112962#M48365 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="320137" data-lia-user-login="shri0025" class="lia-mention lia-mention-user">shri0025</a>&nbsp;,</P><P>Please, provide explanation in words of how to get from 1 (date) to 2 (output).</P><P><img /></P><P>&nbsp;</P> Mon, 04 Oct 2021 07:14:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-To-create-Dax-CAGR-Dax-and-FY-wise-sales-and-Qtr-wise-and/m-p/2112962#M48365 ERD 2021-10-04T07:14:11Z