Dates › Date.AddDays42 / 47

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeDate.AddDays

Date.AddDays: invoice due dates

Mr. Teguh, who owns a baking supplies distributor, gives each wholesale customer different payment terms: 7, 14, 30 or 45 days. The billing team needs a due date column to know which invoices to chase first.

Task

Add a JatuhTempo (due date) column with Table.AddColumn: the date in TanggalFaktur plus the number of days in TerminHari, computed with Date.AddDays (type type date). Result: 5 columns NoFaktur, Pelanggan, TanggalFaktur, TerminHari, JatuhTempo and 6 rows in the source order.

Data sourcesFaktur

Required functionsDate.AddDays

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Run previewCtrlEnter
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
Adding days to a date is best done with a date function, not the + operator with a plain number.
Hint 2
Date.AddDays(date, numberOfDays). Both arguments can be columns of the same row: [TanggalFaktur] and [TerminHari].
Hint 3
#"Added Due Date" = Table.AddColumn(Source, "JatuhTempo", each Date.AddDays(___, ___), type date)

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

let
    Source = Faktur,
    #"Added Due Date" = Table.AddColumn(Source, "JatuhTempo", each Date.AddDays([TanggalFaktur], [TerminHari]), type date)
in
    #"Added Due Date"

Explanation

Date.AddDays handles the calendar correctly: past the end of a month (28 January + 14 days = 11 February), a 28-day February, even a year change (20 December 2024 + 30 days = 19 January 2025). In M, [TanggalFaktur] + 14 actually fails because a date cannot be added to a plain number; what works is date + duration, for example [TanggalFaktur] + #duration(14, 0, 0, 0).
Tip: once you have JatuhTempo, you can compute the receivable age against today's date and bucket it (not yet due, 1-30 days, more than 30 days).

Power Query· sources: Faktur

let
    Source = Faktur
in
    Source

Loading the Advanced Editor…

Edit the M code until the result matches, then press Check answer.

Validation result