Forum Discussion

jmaurer17's avatar
jmaurer17
Frequent Visitor
1 year ago
Solved

Help Needed: Issue with Compounding Contract Year Salary Increase Values

  Hi everyone, I'm encountering an issue with my DAX measure for calculating the cumulative percentage salary increase over multiple contract years. The measure is not correctly compounding the...
jmaurer17's avatar
jmaurer17
Frequent Visitor
1 year ago

Appreciate the response. Here is the input and desired output:

Contract Year Salary Inc input parameter Expected Cumulative % Increase

CY 1 - 2.0%2.00%
CY 2 - 3.0%5.06% (2% compounded with 3%)
CY 3 - 3.0%8.14% (2% → 3% → 3% compounded)

 

So the user a inputs a contract year salary increase percentage for one or all of the contract years. I get numbers close to this figure, but not exact - leading me to suspect a precision error. 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago
    So the user a inputs a contract year salary increase percentage for one or all of the contract years

    How? How does the user input these numbers?

    • jmaurer17's avatar
      jmaurer17
      Frequent Visitor
      1 year ago

      The user inputs a percent increase into one or all (three) Contract Year Salary Inc parameters. I have a seperate numeric paramater for each contract year CY 1 through CY 3 in this case