Most recent record based on date column

[TechR21]

I have a table loaded from an odatafeed with regular refreshes that has a lot of column but following 2 are the most important for this question;

table incidents

- incidentnumber

- modificationdate

Now every incidentnumber can have multiple records, based on the different values of a column. If an incident gets updated, a new row will be added in the table with that incidentnumber together with  a modificationdate value

I want this table to only show unique values of incidentnumbers, so no double incidentnumbers, and only those with the most recent modificationdate

So when there are a few records of incidentnumber 1322 in the table, with below modificationdate, only the last record should be in the table

Incidentnumber        modificationdate

1322                       20/09/2022 09:56:21

1322                       21/09/2022 09:56:21

1322                       21/09/2022 17:56:21

How can i do this? 🙂

[amitchandak]

@TechR21 , Check if these two blogs can help

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...