|
Handling multiple tables on 1 sheet
|
|
5
|
509
|
February 28, 2024
|
|
13 Period Fiscal Calendar (Power Query M function)
|
|
7
|
3540
|
February 26, 2024
|
|
Merge dates across quantity and text flag
|
|
2
|
406
|
February 24, 2024
|
|
Power Query - Automatic filling planning data
|
|
1
|
353
|
February 23, 2024
|
|
Hex to R,G,B in Power Query (M Code)
|
|
3
|
451
|
February 23, 2024
|
|
Budget Allocation M Code
|
|
3
|
455
|
February 23, 2024
|
|
Replacing values in another column using a conversion table Fuzzy match and full match
|
|
5
|
496
|
February 20, 2024
|
|
Merging mutiple similar lists but different languages
|
|
5
|
442
|
February 19, 2024
|
|
Database Structure
|
|
12
|
1763
|
February 16, 2024
|
|
Power Query - Data enrichment ibased on existing information
|
|
10
|
453
|
February 16, 2024
|
|
Problem reading PDF text (source is right-to-left language)
|
|
3
|
372
|
February 16, 2024
|
|
How Secure is credentials stored in Power query for API requests
|
|
4
|
437
|
February 9, 2024
|
|
Pivot table by employeeID/Consecutive days
|
|
2
|
440
|
February 1, 2024
|
|
Replace null values with different values for each row
|
|
3
|
531
|
January 24, 2024
|
|
13 Period Calendar
|
|
9
|
680
|
January 18, 2024
|
|
New Cheat Sheet for Extended Date Table
|
|
10
|
8050
|
January 18, 2024
|
|
Extended Date Table (Power Query M function)
|
|
227
|
107997
|
January 16, 2024
|
|
Transpose data by "Group"
|
|
3
|
413
|
January 15, 2024
|
|
Split Column by Delimiter (each occurrence giving error)
|
|
5
|
421
|
January 13, 2024
|
|
Power BI Connector for Google Analytics 4 Codes
|
|
13
|
2500
|
January 8, 2024
|
|
Errors being generated in Date Table
|
|
3
|
569
|
January 2, 2024
|
|
CSV file from SAP needs Transforming
|
|
4
|
461
|
December 28, 2023
|
|
Unable to change Year Start Date in Extended Dates Table
|
|
4
|
487
|
December 21, 2023
|
|
Date Calendar with holidays in Excel
|
|
2
|
425
|
December 20, 2023
|
|
Tertial in Extended Date Table
|
|
5
|
524
|
December 19, 2023
|
|
Query Filtering Through Other Queries/Lists
|
|
3
|
558
|
December 2, 2023
|
|
Power Query varying column names
|
|
1
|
475
|
November 13, 2023
|
|
Shifts - Roster Planning
|
|
4
|
1890
|
November 13, 2023
|
|
Power Query Data Merge Issue: Client Project
|
|
2
|
472
|
November 10, 2023
|
|
Adding a column from one table based on a value in a second table
|
|
1
|
448
|
November 9, 2023
|