List.Generate(): Create Tables from Thin Air in Power BI with M! - PowerPivotPro

Power Query
Unpivot by number of columns and rows in PowerBI and PowerQuery in Excel – The BIccountant
Bill of Materials Implosion or "Where used Analysis" in Excel and Power BI – The BIccountant
Understanding Power Query Combine - Excelerator BI
Compare Tables in Excel & Power BI - DataChant
Basics of M: Power Query Formula Language | RADACAD
Reduce Development Lag
Power Query (M)agic Part 2: Organizing Your Queries - PowerPivotPro
Pivot your Data using Power Query
Visualizing Merge Join Types in Power BI
Choose the Right Merge Join Type in Power BI
New M-function: Table.TransformColumnTypesToFirstRowsTypes for PowerBI and PowerQuery – The BIccountant
Excel Power Query: Using List.MatchAny on a column value - Stack Overflow
Power BI – Using Functions for repeatability and can easily repeat Applied Steps to your data
Dates Between Merge Join in Power Query | RADACAD
How to open a complex JSON record in Power BI and Power Query
How to analyse M-functions step-by-step? – The BIccountant