New Cheat Sheet for Extended Date Table
|
|
10
|
7508
|
January 18, 2024
|
Extended Date Table (Power Query M function)
|
|
227
|
101524
|
January 16, 2024
|
Transpose data by "Group"
|
|
3
|
250
|
January 15, 2024
|
Split Column by Delimiter (each occurrence giving error)
|
|
5
|
255
|
January 13, 2024
|
Power BI Connector for Google Analytics 4 Codes
|
|
13
|
2231
|
January 8, 2024
|
Errors being generated in Date Table
|
|
3
|
333
|
January 2, 2024
|
CSV file from SAP needs Transforming
|
|
4
|
284
|
December 28, 2023
|
Unable to change Year Start Date in Extended Dates Table
|
|
4
|
315
|
December 21, 2023
|
Date Calendar with holidays in Excel
|
|
2
|
253
|
December 20, 2023
|
Tertial in Extended Date Table
|
|
5
|
315
|
December 19, 2023
|
Query Filtering Through Other Queries/Lists
|
|
3
|
397
|
December 2, 2023
|
Power Query varying column names
|
|
1
|
335
|
November 13, 2023
|
Shifts - Roster Planning
|
|
4
|
1551
|
November 13, 2023
|
Power Query Data Merge Issue: Client Project
|
|
2
|
349
|
November 10, 2023
|
Adding a column from one table based on a value in a second table
|
|
1
|
312
|
November 9, 2023
|
Date table in my visualizations
|
|
1
|
392
|
October 27, 2023
|
Data in column group format
|
|
7
|
521
|
October 21, 2023
|
Interpolate using Power Query
|
|
5
|
576
|
October 16, 2023
|
How to expand parent-child in Power Query/M
|
|
0
|
382
|
October 9, 2023
|
Adding a column to filter by multiple values
|
|
3
|
455
|
October 5, 2023
|
Traverse parent-child relationship in power query
|
|
0
|
409
|
October 4, 2023
|
How to Dynamically change the Power Query Steps for the New File name
|
|
2
|
459
|
October 5, 2023
|
UserPrincipalName.... is there a way to split this value up?
|
|
3
|
550
|
October 3, 2023
|
Finding closest date and value in Multiple column pairs
|
|
4
|
680
|
October 1, 2023
|
Create cost cards, each product with own column and cost associated
|
|
5
|
420
|
September 30, 2023
|
Refresh - DataSource error "duplicate" value
|
|
2
|
439
|
September 29, 2023
|
Combining Bi-Monthly reports to month wise (SAP -ME2J)
|
|
1
|
502
|
September 28, 2023
|
Multiply & add 2 columns that are in Tables
|
|
4
|
398
|
September 26, 2023
|
Removing unwanted Sales data
|
|
5
|
559
|
September 25, 2023
|
Dimension Table
|
|
6
|
647
|
September 23, 2023
|