Power QueryExercises

Return the last step, not an earlier one (kite shop)

The query builds a Line Total column, but the result doesn't show it: the `in` clause returns an earlier step.

Level
beginner
Time
~5 min
Task
Fix a broken query
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Understand that a query's result is the step named after `in`.

Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.

Steps

  1. The starter query keeps orders with Qty of 3 or more and adds Line Total = Qty × UnitPrice, but its result has no Line Total column.
  2. Fix the query so it returns the final step. Don't change what the steps do.
  3. Keep all order columns plus Line Total.

Your result must

  • Only orders with Qty ≥ 3
  • Line Total = Qty × UnitPrice
  • All order columns kept

Input

  • Orders (table)
    • OrderID: text
    • Customer: text
    • Region: text
    • Product: text
    • Qty: number
    • UnitPrice: number
    • OrderDate: text
    • Status: text

Expected output columns

OrderID (text), Customer (text), Region (text), Product (text), Qty (number), UnitPrice (number), OrderDate (text), Status (text), Line Total (number)

First 3 of 8 expected rows
OrderIDCustomerRegionProductQtyUnitPriceOrderDateStatusLine Total
0002Quinn WhitlockNorthStunt Kite654.242026-03-10Cancelled325.44
0003Dmitri HaddadSouthStunt Kite333.72026-03-28Pending101.1
0005Sven MensahSouthDelta Kite942.022026-02-19Pending378.18