How to handle slowly changing dimension

Hi Abhi_PBI 

Create a table

Table 2 = VALUES('Table'[EMP_ID])

Then create measures

Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Application_ID] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[EMP_ID] = MAX ( 'Table'[EMP_ID] )
            && 'Table'[Application Date] <= MAX ( 'Table'[Application Date] )
    )
)

Measure 2 =
CALCULATE (
    MAX ( 'Table'[Application Date] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[EMP_ID] = MAX ( 'Table'[EMP_ID] )
            && [Measure] > 1
    )
)


Measure 3 =
CALCULATE (
    MAX ( 'Table'[New Grade] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[EMP_ID] = MAX ( 'Table'[EMP_ID] )
            && [Application Date] = [Measure 2]
    )
)


Measure 4 = IF([Measure 3]=BLANK(),MAX('Table'[New Grade]),[Measure 3])

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.