Create a new table based on last date and bring all the other values

[Anonymous]

Hi everyone!

I am having difficulties trying to create a new table.

I have this table Cumplimiento de mantenimiento preventivo 

And I would like to create a new table with these data

For each Equipo, I want to have only the data with the most recent date in Campo de fecha del formulario.

I've tried different things with Summarize, Filter with Lastdate etc.. but I still haven't found the solution. 

Thanks a lot for your help!

Jean-Ri

[Anonymous]

It works! Thanks a lot

[amitchandak · Accepted solution]

@Anonymous , Try new column like

filter(addcolumns(Table, "_1", calculate(max(Table[Campo de fecha del formulario]), allexcept(Table, Table[Equipo]))), [Campo de fecha del formulario] =[_1])

I have not tested this