Power QueryExercises

Fix a Changed Type step that breaks two columns (bike rental)

An automatic type step turned customer names into errors and stripped the zeros from order numbers.

Level
beginner
Time
~6 min
Task
Fix a broken query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Check an automatically added Changed Type step and correct the types it chose.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • OrderFile (file)
    • Text file; first line: OrderID,Customer,Qty,UnitPrice
    • Every field is text until you set types

Expected output columns

OrderID (text), Customer (text), Qty (number), UnitPrice (number)