|
About the M Code Showcase category
|
|
1
|
2293
|
March 11, 2020
|
|
Extended Date Table (Power Query M function)
|
|
231
|
122203
|
October 22, 2025
|
|
Power Query - connect to Dataset Tables
|
|
1
|
713
|
September 19, 2025
|
|
Unpivoting multiple alternate rows
|
|
7
|
91
|
August 11, 2025
|
|
Extended Date Table with 4-4-5 fiscal model
|
|
2
|
86
|
June 23, 2025
|
|
Transform PDF Journal Entry to an excel file in Powerquery
|
|
18
|
190
|
December 10, 2024
|
|
Test Filters in M Code
|
|
2
|
127
|
November 25, 2024
|
|
Finding the first and last rows in a non contiguous list
|
|
3
|
93
|
October 8, 2024
|
|
Lookup a Value in a different table and return a value from another column
|
|
1
|
119
|
August 27, 2024
|
|
Geospatial Functions
|
|
1
|
128
|
August 20, 2024
|
|
Determine a lookup key or match for another table
|
|
1
|
69
|
August 20, 2024
|
|
Dynamically Promote Triple Headers (Text,Text & Date)
|
|
1
|
66
|
August 8, 2024
|
|
Extended Date Table Fix
|
|
2
|
678
|
May 4, 2024
|
|
Table Transformation - Column to rows ( Split Columns & append)
|
|
5
|
435
|
April 22, 2024
|
|
Query to join sheets when the path to the file is on a network drive
|
|
7
|
480
|
April 18, 2024
|
|
New book: The Definitive Guide to Power Query (M)
|
|
10
|
1897
|
April 8, 2024
|
|
Dynamic 13 Period Calendar
|
|
6
|
738
|
March 23, 2024
|
|
13 Period Fiscal Calendar (Power Query M function)
|
|
7
|
3765
|
February 26, 2024
|
|
Power Query - Automatic filling planning data
|
|
1
|
391
|
February 23, 2024
|
|
Hex to R,G,B in Power Query (M Code)
|
|
3
|
557
|
February 23, 2024
|
|
Budget Allocation M Code
|
|
3
|
534
|
February 23, 2024
|
|
Replacing values in another column using a conversion table Fuzzy match and full match
|
|
5
|
563
|
February 20, 2024
|
|
Power Query - Data enrichment ibased on existing information
|
|
10
|
511
|
February 16, 2024
|
|
13 Period Calendar
|
|
9
|
762
|
January 18, 2024
|
|
New Cheat Sheet for Extended Date Table
|
|
10
|
8670
|
January 18, 2024
|
|
Unable to change Year Start Date in Extended Dates Table
|
|
4
|
515
|
December 21, 2023
|
|
Date Calendar with holidays in Excel
|
|
2
|
459
|
December 20, 2023
|
|
Tertial in Extended Date Table
|
|
5
|
604
|
December 19, 2023
|
|
Power Query varying column names
|
|
1
|
515
|
November 13, 2023
|
|
Adding a column from one table based on a value in a second table
|
|
1
|
468
|
November 9, 2023
|