Forum Discussion

Charlie42's avatar
Charlie42
Frequent Visitor
4 years ago
Solved

Filter a table to keep the last date

Helle everyone, I have a table like that: doc Val Date doc1 Val1 01/01/2022 doc1 Val1 01/03/2022 doc2 Val2 01/01/2022 doc2 Val2 01/02/2022 doc3 val3 01//02/2022 ...
General Comment
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    Charlie42  sure

    Table =
FILTER (
    tbl,
    tbl[Date]
        = CALCULATE ( MAX ( tbl[Date] ), ALLEXCEPT ( tbl, tbl[doc], tbl[Val] ) )
)

     

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Charlie42  sure

Table =
FILTER (
    tbl,
    tbl[Date]
        = CALCULATE ( MAX ( tbl[Date] ), ALLEXCEPT ( tbl, tbl[doc], tbl[Val] ) )
)