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.

  • lcasey's avatar
    lcasey
    Post Prodigy
    7 years ago

    Thanks!

     

    This is exactly what I was trying to do,  Thank you so much!!!