|
About the Power Query category
|
|
1
|
1791
|
November 12, 2019
|
|
Extended Date Table Fix
|
|
1
|
115
|
April 24, 2024
|
|
Creating a custom function to extract data from folder based on extension
|
|
2
|
128
|
April 24, 2024
|
|
Power Query and access to a folder with lots of pasword protected xlsx files
|
|
1
|
87
|
April 22, 2024
|
|
Table Transformation - Column to rows ( Split Columns & append)
|
|
5
|
147
|
April 22, 2024
|
|
Query to join sheets when the path to the file is on a network drive
|
|
7
|
276
|
April 18, 2024
|
|
How to Make DateEnd parameter equal today
|
|
5
|
162
|
April 18, 2024
|
|
Connecting to API with access token
|
|
3
|
177
|
April 15, 2024
|
|
Help with "if column values do not match another column values then..."
|
|
4
|
101
|
April 11, 2024
|
|
New book: The Definitive Guide to Power Query (M)
|
|
10
|
513
|
April 8, 2024
|
|
Collecting Addresses from disorganised spreadsheets into one
|
|
1
|
189
|
March 28, 2024
|
|
DataSource.Error
|
|
1
|
146
|
March 25, 2024
|
|
Dynamic 13 Period Calendar
|
|
6
|
222
|
March 23, 2024
|
|
Query for a folder results in a null
|
|
1
|
196
|
March 13, 2024
|
|
EDNA Date table - Half Years, Fiscal Years, suffixes and prefixes
|
|
1
|
271
|
March 1, 2024
|
|
Handling multiple tables on 1 sheet
|
|
5
|
289
|
February 28, 2024
|
|
13 Period Fiscal Calendar (Power Query M function)
|
|
7
|
3267
|
February 26, 2024
|
|
Merge dates across quantity and text flag
|
|
2
|
239
|
February 24, 2024
|
|
Power Query - Automatic filling planning data
|
|
1
|
211
|
February 23, 2024
|
|
Hex to R,G,B in Power Query (M Code)
|
|
3
|
273
|
February 23, 2024
|
|
Budget Allocation M Code
|
|
3
|
274
|
February 23, 2024
|
|
Replacing values in another column using a conversion table Fuzzy match and full match
|
|
5
|
275
|
February 20, 2024
|
|
Merging mutiple similar lists but different languages
|
|
5
|
277
|
February 19, 2024
|
|
Database Structure
|
|
12
|
1562
|
February 16, 2024
|
|
Power Query - Data enrichment ibased on existing information
|
|
10
|
272
|
February 16, 2024
|
|
Problem reading PDF text (source is right-to-left language)
|
|
3
|
229
|
February 16, 2024
|
|
How Secure is credentials stored in Power query for API requests
|
|
4
|
258
|
February 9, 2024
|
|
Pivot table by employeeID/Consecutive days
|
|
2
|
278
|
February 1, 2024
|
|
Replace null values with different values for each row
|
|
3
|
337
|
January 24, 2024
|
|
13 Period Calendar
|
|
9
|
505
|
January 18, 2024
|