Forum Discussion
Add index to partition AFTER sort
Kvitekvist how are you pulling this data into the model? is it in excel or what? if you using something like sql i would presort it
Yes i also have editing the SQL as plan B. It would be a skill improve in pbi though if I could solve this in powerquery/m
Kvitekvist you could use this potentially? never tried it though
https://msdn.microsoft.com/en-us/query-bi/m/table-sort
in my personal opinion SQL is the correct tool do this sorting in, but you would potentially get a much faster sort in sql, sorting is a peformance hungry action and if you can use query folding to minimize the performance then that is the best practise.
see this blog post for more info about query folding
http://blogs.adatis.co.uk/callumgreen/post/Query-Folding-in-Power-Query
