Power query top N rows for each group is a common task in data analytics projects. In this video, I am sharing with you guys a very simple method to get tops subgroups based on product count for each product category.
Following functions have been used in it.
Table.selectcolumns
Table.sort
Table.rowcount
Table.TopN
Merge queries etc.
In this channel we will make power bI tutorials on Power BI transformation, Power query and advance DAX plus Power BI Dashboards.
For more to learn & download, please visit https://www.learndax.com/ For complete courses, you can buy these courses from Udemy on discount using the following links
https://www.udemy.com/course/ssas-tab...
https://www.udemy.com/course/power-qu...
https://www.udemy.com/course/microsof...
https://www.udemy.com/course/power-bi...
https://www.udemy.com/course/learn-al...
Skillshare users can follow me on Skillshare for all the courses!
https://www.skillshare.com/r/profile/...