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. CAGR Sale = SUMX(Table1,Table1[...
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(