How do I calculate salary increase for employee

[selected_]

I have compensationHistories table that contain column like employeeid, date, salary. I wanna see how much % the increase was if an employee had salary increase compare to previous. I have tried different ways but can get it. someone please?

[amitchandak]

@selected_ , Please share some data fields to suggest. We can compare salary with last date salary and show increase

a measure using offset for last salary

Current = Sum(Table[Salary])

Prior =

Calculate(Sum(Table[Salary]), OFFSET ( -1,allselected(Table[Employee ID],Table[Date]), orderby(Table[Date]), ,partitionBy(Table[Employee ID])))

Change % = divide([Current]- [Prior], [Prior])

Continue to explore Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

[selected_]

hi,

thanks but i doesn't work, I only get back a 3 records while there are more employee who have increase salary.