PQM.guide

Returns the HTTP response headers for the specified URL as a record.

2026-10-15

How to handle errors gracefully in M using try, otherwise, and error records.

2026-10-15

Returns a record containing the facets (type constraints) of a type, such as precision and scale for decimal types.

2026-10-15

Keeps an initial number of rows, then alternates between skipping and keeping groups of rows.

2026-10-15

Returns true if the date falls within the current calendar month.

2026-10-15

Replaces null values in specified columns with the most recent non-null value above.

2026-10-15

Use if/then/else inside Table.AddColumn to classify, label, and derive values from row data — the most common M transformation pattern.

Understand how null propagates silently through M expressions and learn the standard patterns for defaulting, filtering, and intentionally preserving null values.

Build queries that accept parameters — from simple Power BI parameters to dynamic function-based filtering — without hardcoding values.

Look up values from one table in another — the M equivalent of VLOOKUP — using Table.NestedJoin or direct list lookup patterns.