Forum Discussion
CAGR * Columns
Hi All, i have 5 years of data & have got Dynamic CAGR (% format) into my Dashboard. Now i want to multiply this CAGR with my table. i am using the below formula.
Its Not working.
i have tried the below one too,still its not woking
5 Replies
Hi jaswalsarthak -please find the solved solutions on CAGR
Solved: CAGR - Microsoft Fabric Community
Solved: Calculate CAGR values - Microsoft Fabric Community
Solved: CAGR for multiple periods - Microsoft Fabric Community
https://community.fabric.microsoft.com/t5/Desktop/CAGR-computation/m-p/3219863
Hope this helps.
Hi I am not looking to calculate CAGR, that i have already done, i want to multiply CAGR with my table & that is not working.
Hi jaswalsarthak - Ok, then make sure your CAGR value is correctly calculated as like below:
CAGR Value =
(
(SUM(Table1[Value]) / FIRSTNONBLANK(Table1[Value], 0)) ^
(1 / COUNTROWS(DISTINCT(Table1[Year])))
) - 1If CAGR Value is a measure and not a column, you would need to modify the calculation
CAGR Sale =
SUMX(
Table1,
Table1[Value] * [CAGR Value]
)Hope this helps.
Hi, jaswalsarthak
Thanks for rajendraongole1 reply. After testing, it didn't reproduce your problem, You can simulate a pbix file with simple, non-sensitive data for testing purposes. it will help you to solve the problem faster.Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Like Anonymous wrote it is hard to solve this without more information, but you try adding a CALCULATE to the second SUMX argument, so SUMX(Table1,CALCULATE(
