|
Weekly Updates - Net New + Existing Records
|
|
1
|
260
|
May 23, 2024
|
|
Dynamic data source won't save in Power BI Service
|
|
1
|
242
|
May 23, 2024
|
|
Extended Date Table Fix
|
|
2
|
600
|
May 4, 2024
|
|
Creating a custom function to extract data from folder based on extension
|
|
2
|
424
|
April 24, 2024
|
|
Power Query and access to a folder with lots of pasword protected xlsx files
|
|
1
|
307
|
April 22, 2024
|
|
Table Transformation - Column to rows ( Split Columns & append)
|
|
5
|
419
|
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
|
1090
|
April 18, 2024
|
|
Connecting to API with access token
|
|
3
|
1396
|
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
|
1566
|
April 8, 2024
|
|
Collecting Addresses from disorganised spreadsheets into one
|
|
1
|
386
|
March 28, 2024
|
|
DataSource.Error
|
|
1
|
413
|
March 25, 2024
|
|
Dynamic 13 Period Calendar
|
|
6
|
596
|
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
|
495
|
March 1, 2024
|
|
Handling multiple tables on 1 sheet
|
|
5
|
555
|
February 28, 2024
|
|
13 Period Fiscal Calendar (Power Query M function)
|
|
7
|
3624
|
February 26, 2024
|
|
Merge dates across quantity and text flag
|
|
2
|
424
|
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
|
506
|
February 23, 2024
|
|
Budget Allocation M Code
|
|
3
|
502
|
February 23, 2024
|
|
Replacing values in another column using a conversion table Fuzzy match and full match
|
|
5
|
541
|
February 20, 2024
|
|
Merging mutiple similar lists but different languages
|
|
5
|
457
|
February 19, 2024
|
|
Database Structure
|
|
12
|
1794
|
February 16, 2024
|
|
Power Query - Data enrichment ibased on existing information
|
|
10
|
484
|
February 16, 2024
|
|
Problem reading PDF text (source is right-to-left language)
|
|
3
|
410
|
February 16, 2024
|
|
How Secure is credentials stored in Power query for API requests
|
|
4
|
613
|
February 9, 2024
|
|
Pivot table by employeeID/Consecutive days
|
|
2
|
490
|
February 1, 2024
|
|
Replace null values with different values for each row
|
|
3
|
602
|
January 24, 2024
|