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