Forum Discussion
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 Max(Even_Date) and that would return me only the rows and all the columns in that row with the latest date.
Doesnt seem possible in DAX.
17 Replies
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
