In this blog, we will learn two ranking methods in Power BI – static ranking using Power Query formulas and dynamic ranking using DAX functions. We start with static ranking, where the rank is pre-calculated in Power Query before being pushed to Power BI. We’ll then explore dynamic ranking in Power BI, where ranks are updated based on sales data and dynamically adjusted when filters are applied.
