topic Dynamic Min Value for CAGR in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Min-Value-for-CAGR/m-p/1534827#M30153 <P>Please forgive the linked post but it is eaiser since I have written it once. I am trying to have a dynamic calculation for CARG which will give me a cagr for different services not starting at SFY13,&nbsp; thus the filter is &gt;0. However the attached code doesnt work. Also if i used the filter on date it gives me the entire amount not the min amount of SFY18. I would like the final row to present SFY18: $79. So CAGR would be min amount &gt; 0 and max amount SFY20.&nbsp;</P><P>&nbsp;</P><P><A href="https://stackoverflow.com/questions/65146079/dax-dynamic-beginning-year-cagr" target="_blank" rel="noopener">https://stackoverflow.com/questions/65146079/dax-dynamic-beginning-year-cagr</A>&nbsp;</P> Sun, 06 Dec 2020 17:01:38 GMT Anonymous 2020-12-06T17:01:38Z Dynamic Min Value for CAGR https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Min-Value-for-CAGR/m-p/1534827#M30153 <P>Please forgive the linked post but it is eaiser since I have written it once. I am trying to have a dynamic calculation for CARG which will give me a cagr for different services not starting at SFY13,&nbsp; thus the filter is &gt;0. However the attached code doesnt work. Also if i used the filter on date it gives me the entire amount not the min amount of SFY18. I would like the final row to present SFY18: $79. So CAGR would be min amount &gt; 0 and max amount SFY20.&nbsp;</P><P>&nbsp;</P><P><A href="https://stackoverflow.com/questions/65146079/dax-dynamic-beginning-year-cagr" target="_blank" rel="noopener">https://stackoverflow.com/questions/65146079/dax-dynamic-beginning-year-cagr</A>&nbsp;</P> Sun, 06 Dec 2020 17:01:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Min-Value-for-CAGR/m-p/1534827#M30153 Anonymous 2020-12-06T17:01:38Z Re: Dynamic Min Value for CAGR https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Min-Value-for-CAGR/m-p/1607485#M32281 <P>Hello&nbsp;Anonymous</LI-USER>&nbsp;,<BR />Please check the&nbsp;<A href="https://powerbi.tips/2016/05/measures-calculate-cagr/" target="_self">link</A>&nbsp;.</P> Tue, 19 Jan 2021 06:12:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Min-Value-for-CAGR/m-p/1607485#M32281 Anonymous 2021-01-19T06:12:38Z