By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/rank-substitute-values/

This video shows you how to use the optional, third parameter of the RANKX function to rank a value in a list of other values. You'll learn how to rank a measure calculated for one set of filtered values against a list of values calculated with a different filter which enables you to, for example, rank values for one year against the same list of values in a previous year.

Chapters
00:00 Topic list
00:32 A Basic RankX Example
02:33 Ranking a Filtered Value
04:46 Ranking a Filtered Value Against an Unfiltered Table
09:14 Tidying up the Results
12:47 Ranking Differently Filtered Values
14:38 Comparing Differently Filtered Rankings
17:22 Ranking Values per Year
19:36 Returning a Value from the Previous Year
21:33 Ranking Against the Previous Year's Results
24:50 Adding Conditional Formatting

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!