Power Query from Scratch, Part 5: Parameters, functions and a model that refreshes itself
A hardcoded folder path and a copy-pasted business rule are the same problem, and parameters plus functions are how you stop editing M code every month.
Parameters
// 1 postTutorials, tips, and deep dives on Parameters — every post from bianca.codes tagged Parameters.