Turns out half my old formulas were just dynamic arrays in disguise, written the long way.

Learn how simple M code tweaks in Power Query can help you handle missing columns, rank data flexibly, and fix Excel rounding ...