Need to return previous value in data set

[Zach5152]

Hello, 

So I have a data set with people assigned with multiple dates. I am trying to pull the value(date) prior to. Ex. John has dates 10/12. 10/16 and 10/23 I want to pull the 10/16 date instead of the 10/23 date. 

Can anyone help? 

[v-rzhou-msft · Accepted solution]

Hi @Zach5152 ,

Please try code as below.

Date Before =
VAR _ADDRANK =
    ADDCOLUMNS (
        'Table',
        "Rank", RANKX ( FILTER ( 'Table', [Name] = EARLIER ( [Name] ) ), [Date],, DESC, DENSE )
    )
RETURN
    MAXX ( FILTER ( _ADDRANK, [Rank] = 2 ), [Date] )

My Sample:

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ahmedx]

could you share your pbix-file? Or create an example file which reproduces your issue?