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...
Hello,
Below is a screenshot of the underlying data. I only want to pull those rows with the very latest event date for each company. I highlighted in yellow what the new table would have as rows.
Each yell;ow highlight is the very latest event date for each company.
Could you post a a dataset I could copy/paste?
gracias
Hello,
Here is a link to the actual spreadsheet:
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.