Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Compounding Revenue over 10 years

Hello,

 

I am trying to create a column that yields compounding revenue increase over 10 years.  The column labeled Compounding Revenue Final with 0% change in revenue growth.  The excel sheet displays my expected result.

 

 

The second screenshot is of the Dax I am using which is not generating the desired result.

 

 

Please let me know if there is any other information that would be of assistance.   I am stuck!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This is a screenshot of the 5% revenue increase displayed from the excel sheet, and the numbers I am getting returned

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    This looks like a iterative/recursive logic.

    The result column based on itself.

    As far as I know DAX does not support this calculation.

     

    Best Regards,

    Jay