Forum Discussion

aempa's avatar
aempa
Frequent Visitor
9 years ago
Solved

Growth % in time events

Hello   I have already calculated the salary expenses of my employees over time, with a formula that I show below. Now I want to calculate a growth rate of the salary expenses, over the years and t...
Need Help
  • aempa's avatar
    aempa
    9 years ago

    Thank you spuder. I'm sorry to have so many questions.

     

    I Tried but the result are 0%, any tips?

     

  • spuder's avatar
    spuder
    9 years ago

    In your measure you try to sum up the column [Montante]. But for the totals you need to sum up the column [Salary Atual soma]

spuder's avatar
spuder
Icon for Resolver IV rankResolver IV
9 years ago

Hi aempa, 

 

as long your salary always become bigger you can create a calculated column like this.


Groth = var actual = CALCULATE(MAX(Tabelle2[Salary]);Tabelle2[Employee]=EARLIER(Tabelle2[Employee]))
        var last = CALCULATE(MAX(Tabelle2[Salary]);FILTER(ALL(Tabelle2);Tabelle2[Start]<EARLIER(Tabelle2[Start]));Tabelle2[Employee]=EARLIER(Tabelle2[Employee]))
return
        FORMAT(DIVIDE(actual;last;1);"percent")

 

aempa's avatar
aempa
Frequent Visitor
9 years ago

Thank you spuder, but I don't understand in line 1 and 2, the difference between the two values aren't 102%. Am I reading the data correctly?

 

 

  • spuder's avatar
    spuder
    Icon for Resolver IV rankResolver IV
    9 years ago

    1950 is 102,63% of 1900 (1950*100/1900)

     

    If you wish just the groth you have to divide by 100%

     

    so the result would be 2,63%.

     

    Or am I wrong with your needs?

    • aempa's avatar
      aempa
      Frequent Visitor
      9 years ago

      Sorry, I am a little rookie on this. 

       

      I want to know the growth between January and February or 2012 and 2013.

       

      In this moment, I have this results:

      I can't link the date table because my "Salary atual soma" are influence negatively.

       

      • spuder's avatar
        spuder
        Icon for Resolver IV rankResolver IV
        9 years ago

        In this scenario I would choose the following approach.

         

        Using PREVIOUSMONTH() and PREVIOUSYEAR()