Forum Discussion

Zach5152's avatar
Zach5152
New Member
2 years ago
Solved

Need to return previous value in data set

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? 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.