Power Query practice: Data Types & Strict Type Conversion
Chapter 4 · 5 questions · included in full access
Question 1 · easy
Why types matter
Solve it in your browserA Qty column contains
"12","40","8"as text. What goes wrong?Question 2 · medium
Set the data types
Solve it in your browserSet OrderID to Text, OrderDate to Date, Qty to Whole Number and UnitPrice to Decimal Number. Click the type icon on the left of each header.
Question 3 · easy
Remove blank rows
Solve it in your browserSalesRaw has a completely empty row. Remove it with Home ▸ Remove Rows ▸ Remove Blank Rows.
Question 4 · medium
Case-sensitive filters
Solve it in your browserYour filter is
each [Region] = "north"and it returns no rows, though North orders exist. Why?Question 5 · medium
Strict currency formatting
Solve it in your browserApply strict Currency.Type to UnitPrice and Int64.Type to Qty using
Table.TransformColumnTypes.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing