Filter a table to keep the last date

Question

Helle everyone,I have a table like that:docValDatedoc1Val101/01/2022doc1Val101/03/2022doc2Val201/01/2022doc2Val201/02/2022doc3val301//02/2022&nbsp;With a DAX function, I look for create a new column (or new table) to filter each row with the last date and to have this new table :docValLast Datedoc1Val101/03/2022doc2Val201/02/2022doc3val301//02/2022&nbsp;&nbsp;I look with LASTDATE but I'm not able to find a good (and working) solution.&nbsp;Could you help me ?&nbsp;Thank in advance

smpa01 · Accepted Answer

Charlie42&nbsp; sure
Table =
FILTER (
    tbl,
    tbl[Date]
        = CALCULATE ( MAX ( tbl[Date] ), ALLEXCEPT ( tbl, tbl[doc], tbl[Val] ) )
)

&nbsp;

Forum Discussion

Filter a table to keep the last date

2 Replies

Related content

Filtered table

Can I filter the 1st fact table which then filters a 2nd fact table?

Filtering Table report

How to search specific word in table filter Calculations

Table visual filtering

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

doc	Val	Last Date
doc1	Val1	01/03/2022
doc2	Val2	01/02/2022
doc3	val3	01//02/2022