Forum Discussion

setis's avatar
setis
Post Partisan
5 years ago
Solved

Latest available value

I have a table with WorkDate, Name and Initials.

Using a calculated column, I'm trying to obtain the Initials registered on the last available date for every Name.

This is the expected result:

 

 

I tried this but it's giving me an "out of memory"

Initials 2 =
LOOKUPVALUE (
    Table[Initials],
    Table[WorkDate],
        CALCULATE (
            MAX ( Table[WorkDate] ),
            FILTER (
                Table,
                Table[Name] = EARLIER ( Planday[Name] )
                    && Table[WorkDate] < EARLIER ( Table[WorkDate] )
            )
        )
)

 

  • setis , Try a rank column , you are looking for rank =1

     

    rankx(filter(Table, [Name] = earlier([Name]) ), [WorkDate])

     

    or

     

    if(rankx(filter(Table, [Name] = earlier([Name]) ), [WorkDate]) =1, true(), false())

1 Reply

  • setis , Try a rank column , you are looking for rank =1

     

    rankx(filter(Table, [Name] = earlier([Name]) ), [WorkDate])

     

    or

     

    if(rankx(filter(Table, [Name] = earlier([Name]) ), [WorkDate]) =1, true(), false())