Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
RANKX ties: SKIP and DENSE. RANKX(table, expression, value, order, ties) has three optional arguments. Order is DESC (highest first, the default) or ASC. Ties is SKIP (the default: two months tied for 2nd are followed by 4th) or DENSE (followed by 3rd). To set a later argument without the earlier ones, leave them empty: RANKX(table, [m], , DESC, DENSE).
Units Place = RANKX(ALL(products[product_name]), [Units], , DESC, DENSE)
Operations plans warehouse staff by how busy each month of 2025 was. Several months had exactly the same number of completed orders. The planner wants tied months to share a rank, and the next month to take the next number, with no gaps.
Write the measure Busy Rank on orders: each month's rank by [Orders], most orders first, where tied months share a rank and the following month gets the next whole number. Leave the total row blank. The matrix shows 2025 by month number.
Matrix
Updates as you typeFilters on this visual'Date'[Year] is 2025
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe