Extended Date Table Fix
|
|
2
|
597
|
May 4, 2024
|
Creating a custom function to extract data from folder based on extension
|
|
2
|
404
|
April 24, 2024
|
Power Query and access to a folder with lots of pasword protected xlsx files
|
|
1
|
300
|
April 22, 2024
|
Table Transformation - Column to rows ( Split Columns & append)
|
|
5
|
416
|
April 22, 2024
|
Query to join sheets when the path to the file is on a network drive
|
|
7
|
457
|
April 18, 2024
|
How to Make DateEnd parameter equal today
|
|
5
|
969
|
April 18, 2024
|
Connecting to API with access token
|
|
3
|
1235
|
April 15, 2024
|
Help with "if column values do not match another column values then..."
|
|
4
|
318
|
April 11, 2024
|
New book: The Definitive Guide to Power Query (M)
|
|
10
|
1542
|
April 8, 2024
|
Collecting Addresses from disorganised spreadsheets into one
|
|
1
|
383
|
March 28, 2024
|
DataSource.Error
|
|
1
|
412
|
March 25, 2024
|
Dynamic 13 Period Calendar
|
|
6
|
581
|
March 23, 2024
|
Query for a folder results in a null
|
|
1
|
360
|
March 13, 2024
|
EDNA Date table - Half Years, Fiscal Years, suffixes and prefixes
|
|
1
|
483
|
March 1, 2024
|
Handling multiple tables on 1 sheet
|
|
5
|
551
|
February 28, 2024
|
13 Period Fiscal Calendar (Power Query M function)
|
|
7
|
3619
|
February 26, 2024
|
Merge dates across quantity and text flag
|
|
2
|
423
|
February 24, 2024
|
Power Query - Automatic filling planning data
|
|
1
|
382
|
February 23, 2024
|
Hex to R,G,B in Power Query (M Code)
|
|
3
|
499
|
February 23, 2024
|
Budget Allocation M Code
|
|
3
|
495
|
February 23, 2024
|
Replacing values in another column using a conversion table Fuzzy match and full match
|
|
5
|
538
|
February 20, 2024
|
Merging mutiple similar lists but different languages
|
|
5
|
457
|
February 19, 2024
|
Database Structure
|
|
12
|
1793
|
February 16, 2024
|
Power Query - Data enrichment ibased on existing information
|
|
10
|
483
|
February 16, 2024
|
Problem reading PDF text (source is right-to-left language)
|
|
3
|
406
|
February 16, 2024
|
How Secure is credentials stored in Power query for API requests
|
|
4
|
574
|
February 9, 2024
|
Pivot table by employeeID/Consecutive days
|
|
2
|
485
|
February 1, 2024
|
Replace null values with different values for each row
|
|
3
|
594
|
January 24, 2024
|
13 Period Calendar
|
|
9
|
720
|
January 18, 2024
|
New Cheat Sheet for Extended Date Table
|
|
10
|
8271
|
January 18, 2024
|