Power QueryExercises

Expense claims

Monthly expense claims from a fictional consultancy, with UK-style dates.

What's messy

Columns

ColumnTypeNote
ClaimIDtext
Employeetext
Categorytext
Amountdecimal
ClaimDatetext (dd/mm/yyyy)Convert with en-GB
ApprovedtextYes/No

Try these

How to approach it

Start by setting ClaimDate with Change Type → Using Locale and English (United Kingdom), because the dates are written day first. A plain type change on a machine set to US English reads 05/03/2026 as May 3 and fails on any day above 12. Change Amount to a decimal number and keep Approved as text until you decide how to treat it: filtering to Yes before grouping gives approved spend only, while keeping both values lets you show what is still pending. Then group by Category and sum Amount for a spend summary, and rank each employee's claims to practise grouping with nested tables.

Preview (first 8 rows)

ClaimIDEmployeeCategoryAmountClaimDateApproved
C-0001Idris NovakSoftware12.7113/05/2026Yes
C-0002Jun OkaforTraining156.5423/02/2026No
C-0003Omar KowalLodging64.6803/02/2026No
C-0004Dmitri NovakLodging266.3918/05/2026Yes
C-0005Goran MensahTraining333.4110/06/2026No
C-0006Idris ItoTravel196.9207/04/2026No
C-0007Carmen SilvaTraining433.2918/06/2026Yes
C-0008Esi BrandtMeals38.5618/03/2026Yes

All data is fictional. CSV cells that could be read as spreadsheet formulas are prefixed with an apostrophe.