Forum Discussion
Filtering rows based on a lookup match
Hello everyone,
Here's my table 'Approvals':
Index
Submitter
Submitted_datetime
Status
Approved_datetime
FileID
1
Anne <removed by Admin>
4/1/2020 13:00
Pending
...
Hi annetoal ,
Create a calculated column with this code:
LastItem = IF('Table'[Index] = CALCULATE(MAX('Table'[Index]); ALLEXCEPT('Table'; 'Table'[FileID])); 1; 0)
And filter the visual
Ricardo
I'm sorry, but I don't speak Spanish enough to understand your answer.
Anne