Tuesday, May 5, 2020

Ranking within Groups with Power Pivot

Ranking items is fairly easy to do in Excel whether you're doing it for a table or in a pivot table, but when it comes to showing ranking within groups, you might need to use some combination of functions. This videos show how it can be done with DAX functions (like RANKX and CALCULATE) in Power Pivot. It's actually not too complicated and once you get the hang of using it, the results are pretty neat!


No comments:

Post a Comment