About the M Code Showcase category
|
|
1
|
1939
|
March 11, 2020
|
Dynamic 13 Period Calendar
|
|
6
|
123
|
March 23, 2024
|
13 Period Fiscal Calendar (Power Query M function)
|
|
7
|
3144
|
February 26, 2024
|
Power Query - Automatic filling planning data
|
|
1
|
160
|
February 23, 2024
|
Query to join sheets when the path to the file is on a network drive
|
|
6
|
183
|
February 23, 2024
|
Hex to R,G,B in Power Query (M Code)
|
|
3
|
203
|
February 23, 2024
|
Budget Allocation M Code
|
|
3
|
180
|
February 23, 2024
|
Replacing values in another column using a conversion table Fuzzy match and full match
|
|
5
|
197
|
February 20, 2024
|
Power Query - Data enrichment ibased on existing information
|
|
10
|
205
|
February 16, 2024
|
13 Period Calendar
|
|
9
|
437
|
January 18, 2024
|
New Cheat Sheet for Extended Date Table
|
|
10
|
7339
|
January 18, 2024
|
Extended Date Table (Power Query M function)
|
|
227
|
99444
|
January 16, 2024
|
Unable to change Year Start Date in Extended Dates Table
|
|
4
|
259
|
December 21, 2023
|
Date Calendar with holidays in Excel
|
|
2
|
209
|
December 20, 2023
|
Tertial in Extended Date Table
|
|
5
|
269
|
December 19, 2023
|
Power Query varying column names
|
|
1
|
283
|
November 13, 2023
|
Adding a column from one table based on a value in a second table
|
|
1
|
266
|
November 9, 2023
|
Data in column group format
|
|
7
|
451
|
October 21, 2023
|
Interpolate using Power Query
|
|
5
|
496
|
October 16, 2023
|
How to Dynamically change the Power Query Steps for the New File name
|
|
2
|
401
|
October 5, 2023
|
Create cost cards, each product with own column and cost associated
|
|
5
|
364
|
September 30, 2023
|
Combining Bi-Monthly reports to month wise (SAP -ME2J)
|
|
1
|
446
|
September 28, 2023
|
Multiply & add 2 columns that are in Tables
|
|
4
|
359
|
September 26, 2023
|
Dimension Table
|
|
6
|
585
|
September 23, 2023
|
Reply: Split a single row into multiple rows based on multiple colums
|
|
10
|
437
|
September 12, 2023
|
Power Query - connect to Dataset Tables
|
|
0
|
408
|
September 5, 2023
|
Extended Date Table: Day of Year
|
|
3
|
475
|
August 22, 2023
|
Variance of Year calculation in Power Query
|
|
1
|
514
|
August 10, 2023
|
Month offset for company start and end date
|
|
7
|
484
|
August 3, 2023
|
Triangular Warning Icons
|
|
0
|
414
|
August 1, 2023
|