Power Query - Consecutive Days - PowerPivotPro
Power Query
“In the Previous” Date Filters In Power BI/Get&Transform/Power Query
Unpivoting data in Query Editor: a case study
Pagination & Looping Record Requests
Power BI – Problem, Design, Solution (Folder Source Option for JSON files)
Removing Punctuation From Text With The Text.Select M Function In Power BI/Power Query/Excel Get&Transform
Book Excerpt: Appending Worksheets from a Workbook - DataChant
List.Accumulate Hidden Gem of Power Query List Functions in Power BI
#PowerQuery – Filter a table based on another table column or list – and some Filter aha’s
Date.DatesBetween to retrieve dates between 2 dates in Power BI and Power Query
Power Query M Primer (part 3):Functions: Function Values, Passing, Returning, Defining Inline, Recursion
Power Query - Insert Index by subcategory ie clustered index
Making Sure All Columns Appear When You Combine Data From Multiple Files In Power BI/Power Query M
Power Query M Primer (part 2):Functions: Defining
Enriching your Power BI Solutions with Metadata
Transform Columns with List.Zip
The Extension.Contents() M Function
Power Query (M)agic Part 3: Divide & Conquer
New M function: Function.From
How List.Zip helps with Renaming Columns in Power Query
How to use List.Zip in Power Query
The Environment concept in M for Power Query and Power BI Desktop, Part 1
The Environment concept in M for Power Query and Power BI Desktop, Part 2
Unpivoting SubCategories
IvanBond/Power-Query-Cheat-Sheet
PASS Excel BI VC Webinar - Common Data Patterns #PowerQuery - DataChant
Are there options for the behaviour of function dialogue in M?
Closures, metadata and cascading parameters
Bulk-extracting Power Query M-code from multiple pbix files in Power BI – The BIccountant
Create a function library in power bi using m extensions