Power QueryExercises

Module 3

Data types, locale and nulls

Types, culture-aware conversion of numbers and dates, and the difference between null, blank and error.

You'll be able to

Lessons

  1. 1.Choose types deliberately: identifiers are textPick types that preserve meaning, starting with the rule that identifiers are text.
  2. 2.Convert dates and numbers with a localeUse the source culture so day/month order and decimal separators are interpreted correctly.
  3. 3.null, empty text and errors are different thingsRecognise and handle null, empty text and error values deliberately.
  4. 4.Inspect column types and catch conversion errorsVerify a query's column types and find the rows that failed conversion.

Take the data types, locale and nulls quiz (8 questions)

Exercises