In Power Query Editor, which option on the Add Column tab should you select to create a new column based on a product's unit price where values over $1,000 are labeled High and others Regular?

In Power Query Editor, which option on the Add Column tab should you select to create a new column based on a product's unit price where values over $1,000 are labeled High and others Regular?

• A. Custom column
• B. Conditional column
• C. Index column
• D. Add column from examples

Answer: (B)

Using a conditional rule to label values based on a threshold is what this task tests. In Power Query Editor, you create a new column by defining a condition that checks the unit price and assigns a label accordingly. You’d set it so that if the unit price is greater than 1,000, the new column shows High, and Regular otherwise. This directly expresses the decision for every row without writing code, producing a clear result across the dataset. This approach is the best fit because it matches the exact need: a simple if-then-else labeling based on a numeric threshold, with readable and maintainable logic. Other options would require more manual steps or produce outputs that aren’t suited to this task—for example, one would involve writing a formula in the underlying language, another would add an index, and another would try to infer values from examples rather than enforce a specific rule.

Using a conditional rule to label values based on a threshold is what this task tests. In Power Query Editor, you create a new column by defining a condition that checks the unit price and assigns a label accordingly. You’d set it so that if the unit price is greater than 1,000, the new column shows High, and Regular otherwise. This directly expresses the decision for every row without writing code, producing a clear result across the dataset.

This approach is the best fit because it matches the exact need: a simple if-then-else labeling based on a numeric threshold, with readable and maintainable logic. Other options would require more manual steps or produce outputs that aren’t suited to this task—for example, one would involve writing a formula in the underlying language, another would add an index, and another would try to infer values from examples rather than enforce a specific rule.