Closures, metadata and cascading parameters
M Parameterized Function for Power Query
Creating Power Query Functions | The Microsoft MVP Award Program Blog
Mundane Essays: Power BI tip: Parameters table for Power Query queries to connect to different databases
Data-Driven Power BI Desktop Parameters Using List Queries – Chris Webb's BI Blog
Share and Refresh Power Query with Local Links - PowerPivotPro
Matchlists/tables in power query
Text Contains Any Of
How to use Record.Field for a list
Finding text strings of table inside text strings of other table
Power Query – Adding Parameters within a piece of text