Forum Discussion
Solved
Create new Table from Last record
Hello, Is there a way to grab only the LAST record for a bunch of records based on the latest date? In SQL server it is super east and extreemly fast. I woudl simply select * from all rows with M...
try like this:
FILTER(
NATURALINNERJOIN(
Table_query__1,
SUMMARIZECOLUMNS(
Table_query__1[Company Name - Nombre de Empresa],
"MaxEventDate", MAX( Table_query__1[Event Date - Fecha de Evento] )
)
),
[MaxEventDate] = [Event Date - Fecha de Evento]
)
Unfortunatly that doesnt work.