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 instea...
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.

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

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