Forum Discussion

Himanshu's avatar
Himanshu
Frequent Visitor
8 years ago

Dynamic CAGR

Hi ,   I have created CAGR folmula as per the "https://powerbi.tips/2016/05/measures-calculate-cagr/".   NoofYrs = 2 FILTER(ComData,ComData[Year]=(MAX(ComData[Year])-2) FILTER(ComData,ComData[Y...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Himanshu,

Do you get issues when creating dynamic CAGR? If so, please share more details about your scenario and post expected result here.

If you just share the DAX you use to calculate CAGR as per the filter selection, thanks for your sharing the formula.

Regards,
Lydia