Forum Discussion

annetoal's avatar
annetoal
Icon for Helper II rankHelper II
6 years ago

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 ...
Need Help
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

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
  • annetoal's avatar
    annetoal
    Icon for Helper II rankHelper II
    6 years ago

    I'm sorry, but I don't speak Spanish enough to understand your answer.

    Anne