Power QueryExercises

Treat empty text and null the same (hardware)

Some suppliers are null and some are empty text. Standardise both to "Unknown".

Level
intermediate
Time
~7 min
Task
Build the query
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Tell null and empty text apart, and standardise them explicitly.

Tinker Depot (fictional) runs two warehouses for hardware supplies and exports stock levels nightly.

Steps

  1. In Supplier, replace both null and empty text ("") with Unknown.
  2. Keep both columns and all rows.

Your result must

  • No null or empty Supplier values
  • Real supplier names unchanged
  • All rows kept

Input

  • Stock (table)
    • Item: text
    • Supplier: text (nullable)

Expected output columns

Item (text), Supplier (text)

First 3 of 4 expected rows
ItemSupplier
SKU-001 HingeBolt & Co
SKU-002 HingeUnknown
SKU-003 Drill BitGrainline