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
lcasey's avatar
lcasey
Post Prodigy
7 years ago

Hello,

 

This is not a SQL server connection, but a SharePoint connection so I cant create a view of the data.  Power BI imports the entire table.

 

I really appreciate you taking all this time to help, I thought this would be so simple but it really is very complicated to create a table filtered to only the latest record for each case.

 

Thanks again.

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

    Hi,

     

    In certain tabs of the report I am using the entire table, but for a certain tab, I just need the latest record.   There are not too  many records and the tqble will probably never go beyond 10 thousand actual records.

     

    Again, thank you so much for your help on This!

  • 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!