Forum Discussion

Zaynah16's avatar
Zaynah16
Icon for Helper I rankHelper I
4 years ago

CAGR for Group

HI guys,    Please could I get help with the following:  I ned to calculate a CAGR value for a group, I have done so with the individual business units on a link and stacked bar chart but I need a...
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

If you're calculating CAGR in Access, then that's where you should calculate the group CAGR too since it's not an additive measure you can just aggregate in Power BI. If you go this route, you may be interested in reading this post I wrote a while back:
Handling Subtotals for Pre-Calculated (Non-Additive) Measures

 

The other option is to do all your CAGR calculations in Power BI rather than Access. DAX can handle these sorts of calculations just fine and you don't have to worry about the granularity scope as much.

Zaynah16's avatar
Zaynah16
Icon for Helper I rankHelper I
4 years ago

Do you have a solution on how to calculate the CAGRS in power bi ? 

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    It's a simple formula in principle but I'm not sure how you aggregate separate timeframes together.

     

    If you can provide some sample input and expected output, I can probably help. Your given sample data doesn't make much sense to me though. The value 1 and value 2 don't appear to correspond to the CAGR in that row.