[Solved] Given this DAX expression:SortedTable = SORTBY('Sales', 'Sales'[Amount], DESC)What will be the order of rows in SortedTable? | Power BI

Power BI - Power Query Editor

Given this DAX expression:

SortedTable = SORTBY('Sales', 'Sales'[Amount], DESC)

What will be the order of rows in SortedTable?

ARows sorted by Amount randomly

BRows sorted by Amount in ascending order (smallest to largest)

CRows sorted by Amount in descending order (largest to smallest)

DRows remain in original order

Step-by-Step Solution

Solution:

Step 1: Understand the SORTBY function parameters
SORTBY sorts the table by the specified column and order. Here, 'Amount' column is sorted DESC (descending).
Step 2: Determine the sorting result
Descending order means largest values first, so rows will be ordered from largest to smallest Amount.
Final Answer:
Rows sorted by Amount in descending order (largest to smallest) -> Option C
Quick Check:
SORTBY with DESC = Descending order [OK]

Quick Trick: DESC means sort from largest to smallest [OK]

Common Mistakes:

Master "Power Query Editor" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

Given this DAX expression: