Question

You are preparing a sales table in Power Query. Business users need a text column called 'Deal Size' that displays 'Large' when the OrderAmount is 10000 or greater, 'Medium' when it is between 1000 and 9999.99, and 'Small' otherwise. You want to build this using the Power Query Editor UI with the least amount of custom code. Which feature should you use?

Accepted Answer

Add a Conditional Column and define the if/then rules based on OrderAmount ranges

Answer

Add a Custom Column and write a nested SWITCH DAX expression

Answer

Use Column from Examples and type sample outputs for a few rows

Answer

Group By OrderAmount and add a text aggregation column