Forum Discussion
setis
5 years agoPost Partisan
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
- amitchandakSuper User
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())