Power QueryExercises

Round halves two ways: to even and away from zero (fuel)

Finance rounds half-amounts away from zero, but Power Query's default rounds them to the nearest even number. Show both.

Level
intermediate
Time
~8 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Know Number.Round's default (half to even) and choose a rounding mode explicitly.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • Ledger (table)
    • Line: text
    • Amount: number

Expected output columns

Line (text), Amount (number), Default Rounded (number), Invoice Rounded (number)