Forum Discussion

lcasey's avatar
lcasey
Post Prodigy
7 years ago
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...
Need Help
LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

lcasey

 

by the way, if in your model you are not using the entire table and you only need data for the latest record of each group then it would be better to perform this operation within Power Query and do not overload the model with unecessary data. If that is the case then i can provide a M solution

lcasey's avatar
lcasey
Post Prodigy
7 years ago

Hello,

 

I noticed that there are duplicates in the new table that was created.  Do you know why some records are returned more than one time?

 

 

  • lcasey's avatar
    lcasey
    Post Prodigy
    7 years ago

    I see why the duplicates are there.  On the event Date, sometimes there are multiple records with the same exact date causing the table to load multiple records for a company.

     

    I will need to modify the dates to be unique...:)   Thanks again!