Forum Discussion
Solved
Finding top 5s of multiple actors
Hello there everyone, so I've joined some date sets/tables and am almost done with my assignment, I "only" need to determine the top 5 categories of the 5 actors who play the most roles. The latt...
If to imitate on such model
first you group by actor_id without aggregation
next sort each Data table by Qty (simplest by adding another column)
and keep Top5 in resulting table
Remove intermediate columns and expand latest one
.png){kind=link}
I'm on the most recent version of excel.
How would I implement this in power query?
How would I implement this in power query?
If to imitate on such model
first you group by actor_id without aggregation
next sort each Data table by Qty (simplest by adding another column)
and keep Top5 in resulting table
Remove intermediate columns and expand latest one
I have no idea how you came up with this.
But it worked perfectly! Thank you so much!
And the excel file helped alot
Mmrtlm , you are welcome.
In general you may combine all transformations of grouped tables in one function instead of adding new columns for each transform, but that's cosmetic.