Excel Power Query Generator — illustrative example

INPUT
Write a self-contained Power Query M example. Source columns ID and Amount are text. Rows: ID " A01 ", Amount "12.50"; ID "B02", Amount "oops". Trim ID and convert Amount using en-US; keep invalid amounts visible as errors rather than dropping rows.

RESULT
let
    Source = #table(
        type table [ID = text, Amount = text],
        {{" A01 ", "12.50"}, {"B02", "oops"}}
    ),
    Trimmed = Table.TransformColumns(
        Source, {{"ID", Text.Trim, type text}}
    ),
    Typed = Table.TransformColumnTypes(
        Trimmed, {{"Amount", type number}}, "en-US"
    )
in
    Typed

Expected result in Power Query:
A01 → Amount 12.5
B02 → Amount Error, because "oops" cannot be converted to a number.
Both source rows remain available for inspection. This example has been checked against the documented functions; it is not a recorded Power Query execution.

REVIEW
Power Query code should match the actual source schema and locale. Order transformations so type changes and filtering do not silently lose records.

This is a teaching example, not a live execution record.