Power Query practice: Date & Time Intelligence
Chapter 7 · 5 questions · included in full access
Question 1 · medium
Date filter
Solve it in your browserOrderDate is already typed as a date. Keep orders placed on or after 1 February 2026. Use ▾ ▸ Date Filters ▸ Is After Or Equal To.
Question 2 · medium
Month name
Solve it in your browserAdd a Month Name column from OrderDate: select it, then Add Column ▸ Date ▸ Month ▸ Name of Month.
Question 3 · hard
Due date
Solve it in your browserPayment is due 30 days after the order. Add a Due Date custom column using
Date.AddDays.Question 4 · medium
Month start boundary
Solve it in your browserAdd a custom column MonthStart snapping each OrderDate to the first day of that month using
Date.StartOfMonth.Question 5 · hard
Calculate aging days
Solve it in your browserCalculate order aging: add DaysOld as the integer days between
#date(2026, 3, 31)and OrderDate usingDuration.Days.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing