I’ve just learned some really interesting new Power Query/M optimisation tricks! I’m going to write them up here as a series of worked examples rather than generalised patterns because I’m still ...

For this particular query, using the Table.FirstN function to get the first row of the table like so: Table.FirstN(#”Sorted Rows”,1)[Column2]{0} …allows for another internal optimisation to kick in, ...