Power QueryExercises

Module 7

Numbers, dates and conditional columns

Rounding, date parts, durations and conditional logic.

You'll be able to

Lessons

  1. 1.Conditional columns with if … then … elseWrite conditional logic that is correct at the boundaries.
  2. 2.Rounding numbersRound results to a fixed number of decimals and know which rounding mode applies.
  3. 3.Date parts and durationsDerive reporting periods and elapsed days from real date values.
  4. 4.Month starts, month ends and period keysTurn dates into reporting periods and calculate due dates from period boundaries.

Take the numbers, dates and conditional columns quiz (8 questions)

Exercises