find previous value in a snapshot table

Hi,

Please check the below picture and the attached pbix file.

job_id_previous_month CC =
VAR _currentrowemployee = data[employee_id]
VAR _currentrowmonth = data[snapshot_date]
RETURN
    MAXX (
        FILTER (
            data,
            data[employee_id] = _currentrowemployee
                && data[snapshot_date] = EOMONTH ( _currentrowmonth, -1 )
        ),
        data[job_id]
    )

Hello coollehavre , 

Please try the below code..

job_id_previous_month =
VAR currentEmployee = 'Table'[employee_id]
VAR currentDate = 'Table'[snapshot_date]
RETURN
CALCULATE(MAX('Table'[job_id]),FILTER('Table','Table'[employee_id] = currentEmployee &&

EOMONTH('Table'[snapshot_date], 0) = EOMONTH(currentDate, -1)))

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN