Forum Discussion

shri0025's avatar
shri0025
Icon for Helper II rankHelper II
4 years ago

How To Create CAGR % FY and month wise

Hello,

 

I am unable to create the Month wise CAGR % in PowerBI.

 

I can create year on year CAGR FY to FY but unable to create the same for Month to Month.

 

Data:

 

Output required:

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi shri0025 ,

     

    I am working on how to write this Dax that you need, maybe you can refer to this link below first to see if it will help you.

    Dynamic CAGR Calculation in DAX 

     

    Hope it helps,


    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • shri0025's avatar
      shri0025
      Icon for Helper II rankHelper II
      4 years ago

      Hi Anonymous  Not help  as my output  show montn to month CAGR%  i need FY month to month CAGR%