Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Calculate Percentage Last Increase

Hello! I have the following information in the dataset. My datasets are distinguished from month to month by the "last day of the month" column. Employee ID Last day of the month Last Increa...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Syndicate_Admin 
Here is a sample file with the solution https://www.dropbox.com/t/VxePA5I71I36fxiz

Last % increase = 
VAR CurrentDate = Payroll[Last day of the month]
VAR CurrentSalary = Payroll[Monthly Total]
VAR CurrentEmployeeTable = CALCULATETABLE ( Payroll, ALLEXCEPT ( Payroll, Payroll[Employee ID] ) )
VAR DatesBeforeTable = FILTER ( CurrentEmployeeTable, Payroll[Last day of the month] < CurrentDate )
VAR PreviousDate = MAXX ( DatesBeforeTable, Payroll[Last day of the month] )
VAR PreviousSalay = MAXX ( FILTER ( DatesBeforeTable, Payroll[Last day of the month] = PreviousDate ), Payroll[Monthly Total] )
RETURN
    DIVIDE ( CurrentSalary - PreviousSalay, PreviousSalay, 0 )