Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Min Value for CAGR

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,  thus the filter is >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 > 0 and max amount SFY20. 

 

https://stackoverflow.com/questions/65146079/dax-dynamic-beginning-year-cagr 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello Anonymous ,
    Please check the link .