Using a condition to select which column to use for merge
|
|
6
|
1205
|
March 9, 2023
|
Adding Fiscal Months and 4-5-4 format to Dates Table
|
|
3
|
1062
|
March 8, 2023
|
The Number of Working Hours Between two Times
|
|
2
|
732
|
March 8, 2023
|
Dynamic "IsLast4Quarters" in Extended DNA Date Table
|
|
1
|
570
|
March 7, 2023
|
Extended Date Table - Add Agile Sprint schedule
|
|
11
|
2219
|
March 6, 2023
|
Dynamic Query Parameter. Troubleshooting help
|
|
7
|
1178
|
March 6, 2023
|
M Code I can add to my date table
|
|
6
|
2247
|
March 6, 2023
|
Moving a Duplicate Value from a Row to a Column
|
|
2
|
840
|
March 2, 2023
|
How to select more than one table from a file when importing identical files from a folder
|
|
21
|
2146
|
March 1, 2023
|
Using a field from another query in a custom column
|
|
5
|
1220
|
February 28, 2023
|
Is it possible to use dynamic security in a Datamart?
|
|
4
|
1029
|
February 27, 2023
|
Dynamically change column names and corresponding measures
|
|
21
|
3909
|
February 27, 2023
|
Bulk Find and Replace on partial cell values
|
|
3
|
895
|
February 23, 2023
|
Combining multiple fact tables that are split into years
|
|
4
|
760
|
February 21, 2023
|
Removing Stop words using Power Query
|
|
5
|
1438
|
February 19, 2023
|
Null date value logic in PQ
|
|
5
|
837
|
February 17, 2023
|
Dynamic Column Names
|
|
6
|
1346
|
February 16, 2023
|
Dynamic Product Season change
|
|
3
|
614
|
February 16, 2023
|
SQL connection staying open
|
|
7
|
692
|
February 15, 2023
|
Count of employee based on months and job grade (raw data doesn't have rows and columns)
|
|
27
|
1762
|
February 14, 2023
|
Last working day of the month
|
|
3
|
942
|
February 14, 2023
|
Why fill in {"1".."10"} reporting (An error occurred in the ‘’ query. Expression.Error: The value isn't a single-character string. Details: Value=10)
|
|
6
|
943
|
February 12, 2023
|
Replacing dates by word
|
|
10
|
704
|
February 9, 2023
|
Date of last refresh is in PST and Today date Is picking in UTC Date
|
|
6
|
817
|
February 8, 2023
|
Power Query Challenge - Repeat Rows for Courses across Years
|
|
3
|
909
|
February 3, 2023
|
How to protect the API Token, when sharing the PBIX file with others
|
|
1
|
642
|
February 3, 2023
|
Tranform a complex TXT file in a proper usuable format
|
|
1
|
608
|
February 2, 2023
|
Replace values in one column with multiple conditions in another column in a single step using M
|
|
9
|
747
|
February 1, 2023
|
Error handling in custom functions
|
|
3
|
760
|
February 1, 2023
|
User Power query to process multiple excel files and each has multiple worksheets
|
|
6
|
764
|
January 26, 2023
|