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,
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.
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