How To Create Ranking in Power Query with Table.Selectrows & Table.AddIndexColumn | Power BI | Excel

I am getting an impossibly slow refresh with this. Does anyone know how I can wrap this in a Table.Buffer? I don't really understand the syntax of it and where to put it. I don't want to do it in the Advanced Editor, if possible. Thanks in advance!

Absolutely fantastic!!! Couldn't have come at a better time. Thanks so much.

Thanks 👌

brilliant explanation
I wonder why PQ/M gets so complex to do stuff that requires very little effort in SQL or R..

Good One

******************************************************************************************************************************
Dataset - Create a blank query in Power Query with this:
******************************************************************************************************************************

let
Source = Table.FromRows (
Json.Document (
Binary.Decompress (
Binary.FromText (
"fVbbitswEP0Vk+elWLaU2I97oaVQ2tANDWXZB+9arEUcKyjOhvTra0cjRR5JfjLonBnNnLnILy+L+y/JU9Wf9ou7xTfFeTd8Sbp4vZsisq2HD/POFb8Mn9IzeBbtJ1ejrzwMJWBKCoyvRbcbPpln+NCe+PDxzu//nRQPhv3QVu+jL+IF/ktV3cdolGUaqj951w9+kq1Uu+MtNePUw7eN6EcHKxIh/Oa1k78H3xQqVhEKJExiN5j0iiJGUPI8FjTTHh5l18ujdNNnCIBCU3QMNaHYD4jEUnRuxCF0iRBUfWxoVckIjgFlOwni2ra0xBaQPsFZgrAsQ+e6ZAxf8Je3rTyPQV2Br9WbErtq0uY5xRAoWXjnkDkE5SDQMGnAQo/lEiO2vuG4jMolhqGcvj+ty9IL2taTeJCdMWgyB7JdRnWH/xD9ubqOqkVIhhCr6LJEiLkoxyYQNcXnoCdBxyYXliPAlhkDIGOGIzKFyQoEmBWGA4VyUd0sP6Xqm7Po6mSjqporZ2lEcRN8Fqc4iyXKMas0HojNrZxxApW/MtZKHvm0IswDjJKrgIl2BmVHRtdQfCOjRpF6kFWB+VFMGuNZnvpGifqDJ39EzSdLiKYxClotAQZaGgGGHaroLWZXRKOAByKOg6hFjKGl0CFuKtEeD6JLNvLiNEkZBKHFWRC0uZOIYx3WKogaWfIgetsPQdidn03Dk3UjO548yv2h6i5OA6ZRBv5zCXHMcxi/Ri9/mMAQw24zFqXYWdfl2Q4lG1/2tk6+7w/DPNpBvdh3Js7RL8gcyTTTrCetL52j3N7E2evsGp69z3bwrAZQj/n0YGLZHMlt3Nf/",
BinaryEncoding.Base64
),
Compression.Deflate
)
),
let
_t = ( ( type nullable text ) meta [ Serialized.Text = true ] )
in
type table [ Brand = _t, Color = _t, SalesAmount = _t ]
)
in
Source


******************************************************************************************************************************
Complete solution:
******************************************************************************************************************************

let
Source = Table.FromRows (
Json.Document (
Binary.Decompress (
Binary.FromText (
"fVbbitswEP0Vk+elWLaU2I97oaVQ2tANDWXZB+9arEUcKyjOhvTra0cjRR5JfjLonBnNnLnILy+L+y/JU9Wf9ou7xTfFeTd8Sbp4vZsisq2HD/POFb8Mn9IzeBbtJ1ejrzwMJWBKCoyvRbcbPpln+NCe+PDxzu//nRQPhv3QVu+jL+IF/ktV3cdolGUaqj951w9+kq1Uu+MtNePUw7eN6EcHKxIh/Oa1k78H3xQqVhEKJExiN5j0iiJGUPI8FjTTHh5l18ujdNNnCIBCU3QMNaHYD4jEUnRuxCF0iRBUfWxoVckIjgFlOwni2ra0xBaQPsFZgrAsQ+e6ZAxf8Je3rTyPQV2Br9WbErtq0uY5xRAoWXjnkDkE5SDQMGnAQo/lEiO2vuG4jMolhqGcvj+ty9IL2taTeJCdMWgyB7JdRnWH/xD9ubqOqkVIhhCr6LJEiLkoxyYQNcXnoCdBxyYXliPAlhkDIGOGIzKFyQoEmBWGA4VyUd0sP6Xqm7Po6mSjqporZ2lEcRN8Fqc4iyXKMas0HojNrZxxApW/MtZKHvm0IswDjJKrgIl2BmVHRtdQfCOjRpF6kFWB+VFMGuNZnvpGifqDJ39EzSdLiKYxClotAQZaGgGGHaroLWZXRKOAByKOg6hFjKGl0CFuKtEeD6JLNvLiNEkZBKHFWRC0uZOIYx3WKogaWfIgetsPQdidn03Dk3UjO548yv2h6i5OA6ZRBv5zCXHMcxi/Ri9/mMAQw24zFqXYWdfl2Q4lG1/2tk6+7w/DPNpBvdh3Js7RL8gcyTTTrCetL52j3N7E2evsGp69z3bwrAZQj/n0YGLZHMlt3Nf/",
BinaryEncoding.Base64
),
Compression.Deflate
)
),
let
_t = ( ( type nullable text ) meta [ Serialized.Text = true ] )
in
type table [ Brand = _t, Color = _t, SalesAmount = _t ]
)
in
Source

DaxStar+MStar= Antriksh Sharma

Amazing stuff, you are really talented

Nice Explanation Really like it (Y).

Can I have the source file of the data. ?