Year over Year salary % increase for each employee

[puru]

Hello everyone,

For following situation how can I calculate year over year salary increase in percentage for each employee? 

PLEASE HELP! 

Thanks for any help!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my solution from here.

Hope this helps.

[Shilpi27]

Hi unable to access the link... can u share the solution. Have a similar problem to calculate yoy percentage increase in salary of employees 

[Ashish_Mathur]

I do not have that file now.  Share soen data, explain the question and show the expected result.

[Phil_Seamark]

HI @puru

The following calculated column should be close.  Just changed where I have 'Table3' with your own tablename, and make sure you format the column as a percentage.

Percentage Change = 
VAR LastYearSalary = 
    CALCULATE(
        SUM('Table3'[Salary]),
        FILTER(
            'Table3',
            'Table3'[Employee] = EARLIER('Table3'[Employee]) &&
            'Table3'[Year] = EARLIER('Table3'[Year])-1)
            )
Var ThisYearSalary =  'Table3'[Salary]          
RETURN IF(NOT ISBLANK(LastYearSalary),DIVIDE( (ThisYearSalary- LastYearSalary) , ThisYearSalary))

[mattbrice]

A couple other small points:  YoY is usually calculated as :   LastYear - ThisYear / LastYear.  And Divide function has a third parameter to return an alternate result in case of divide by zero scenario.  So for last line you could do this :

RETURN DIVIDE( ThisYearSalary - LastYearSalary , LastYearSalary, 1 )

Or if you want to return BLANK(), just omit third parameter.