Question

You are building a Fabric warehouse view for a sales report. The source fact table has a column OrderAmount (decimal). The reporting team needs a derived text column named AmountBand that classifies each row as 'Small' when OrderAmount is under 100, 'Medium' when it is 100 to 499.99, and 'Large' when it is 500 or greater. You want the logic contained in a single reusable T-SQL SELECT expression. Which approach correctly produces the AmountBand column?

Accepted Answer

Use a CASE expression: CASE WHEN OrderAmount < 100 THEN 'Small' WHEN OrderAmount < 500 THEN 'Medium' ELSE 'Large' END AS AmountBand

Answer

Use COALESCE(OrderAmount, 'Small', 'Medium', 'Large') AS AmountBand to pick the matching label

Answer

Use IIF(OrderAmount, 'Small', 'Medium', 'Large') AS AmountBand with all three labels as arguments

Answer

Use CAST(OrderAmount AS VARCHAR) AS AmountBand and let the report bin the values