Hi All!
I am trying to calculate the CAGR for 3 consecutive quarters in PowerPivot. I can't see to get the formula right. This is what I have tried.
The error I receive is that each field can't be determined in the current context.
Any help is greatly appreciated. I guess I am just having trouble figuring what order these formulas should be.
I am trying to calculate the CAGR for 3 consecutive quarters in PowerPivot. I can't see to get the formula right. This is what I have tried.
Code:
Past 3 Qtr CAGR:=('Bookings Past 3 Quarters'[Prior Qtr -2 Bookings]/'Bookings Past 3 Quarters'[Prior Qtr Bookings])^(1/3)-1
Past 3 Qtr CAGR:=([Prior Qtr -2 Bookings]/[Prior Qtr Bookings])^(1/3)-1
The error I receive is that each field can't be determined in the current context.
Any help is greatly appreciated. I guess I am just having trouble figuring what order these formulas should be.