Book Excerpt: Basic Text Analytics using Power BI and Power Query in Excel - DataChant

Power Query
Split CamelCase headers in M - DataChant
Writing documentation for custom M-functions, Part2 | THE SELF-SERVICE-BI BLOG
Extract Data Based on the Previous Row - The Ken Puls (Excelguru) Blog
Split multiple columns into rows in #PowerQuery - Prathy's Blog...
Re: Create tables based on all Query Parameters
Working with ranges (Numbers/Dates) in Power Query/Power BI - Part 2
Re: Pass parameters to Adcanced Editor
Dynamic option sets in PowerBI
Setting SQL Server Connection String Properties In Power BI and SSAS Tabular Modern Data Sources
Using SSAS Multidimensional As A Data Source For Power BI (Video)
Adding Try Results is Trying - The Ken Puls (Excelguru) Blog
List.SelectPositions in Power BI and Power Query – The BIccountant
Table.Group: Exploring the 5th element in Power BI and Power Query – The BIccountant
Power Query M Primer (Part 4): Variables & Identifiers
Quirks of Visual Studio Query Editor working with Analysis Services
Writing documentation for custom M-functions, Part1 | THE SELF-SERVICE-BI BLOG
The Each Keyword in Power Query - The Ken Puls (Excelguru) Blog
Remove repeating characters from a string in Power BI and Power Query – The BIccountant
Power Query - Consecutive Days - PowerPivotPro
“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