Most current date of a category

[Anonymous]

Hello,
I have these columns in my data source and I'm trying to view the document that contains the most recent update.

Ex: I have a document DOCID = 1 And I want to bring the one with the most recent update date, for each different company. How could you do that in power bi?

Thanks to anyone who can help

how is it

how I want it to be

[amitchandak · Accepted solution]

@Anonymous , Use this for date updated in a visual table

New measure for last update date =

calculate(max(Table[dateupdated]), filter(Table, Table[Date] = calculate(max(Table[dateupdated]), allexcept(Table, Table[Comapny], Table[Doc ID]))))

if needed use similar formula for other columns other than Doc ID and Company