Selectedvalue to determine previous year and pass to variable

[Anonymous]

Hi, I have an issue. I´m trying to calculate the payroll of the employees of a company based on a year selected in a slicer. The problem is that I need the payroll for the year selected and the previous but in some cases an employee change of unit and his "id" number change too, so when I put the employee his payroll for previous year disapare.

These are the measures that I am using:

Nómina Actual =

VAR SelectedFecha = SELECTEDVALUE(T2C_Facts_Nominas_PRUEBA[FECHA])

RETURN

CALCULATE(

    SUM(T2C_Facts_Nominas_PRUEBA[Nómina]),

    T2C_Facts_Nominas_PRUEBA[FECHA] = SelectedFecha

)

Nómina Anterior =

VAR SelectedFecha = SELECTEDVALUE(T2C_Facts_Nominas_PRUEBA[FECHA])-1

RETURN

CALCULATE(

    SUM(T2C_Facts_Nominas_PRUEBA[Nómina]),

    T2C_Facts_Nominas_PRUEBA[FECHA] = SelectedFecha

)

If I manually put the previous year in the formula it works fine, if I use selectedvalue-1 it doesn't work as I would like

Thanks in advance

[lbendlin]

Please read about SCD - slowly changing dimensions - and how to handle them in Power BI.