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 lcasey
Should be possible with DAX as well. If you post a sample data set along with expected results we can have a look.
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:
