|
About the M Code Showcase category
|
|
1
|
1243
|
March 11, 2020
|
|
Extended Date Table (Power Query M function)
|
|
209
|
77466
|
June 4, 2023
|
|
Date Format Issue in Power query
|
|
7
|
141
|
May 29, 2023
|
|
Sort by Chart of Accounts
|
|
7
|
64
|
May 28, 2023
|
|
Find nearest date for a row, same customer, same table?
|
|
12
|
133
|
May 18, 2023
|
|
Expand data after a table merge with conditionals
|
|
5
|
96
|
May 12, 2023
|
|
Power Query - create table
|
|
5
|
178
|
April 20, 2023
|
|
Creating Calendar with Week & Month Cutoff
|
|
2
|
149
|
April 13, 2023
|
|
Conditional merging two tables with New rows
|
|
6
|
168
|
April 10, 2023
|
|
PQ strange behavior when filtering errors
|
|
4
|
140
|
April 10, 2023
|
|
List Generate first step
|
|
4
|
172
|
April 5, 2023
|
|
Extended Date Table - Add Agile Sprint schedule
|
|
11
|
1224
|
March 6, 2023
|
|
M Code I can add to my date table
|
|
6
|
1529
|
March 6, 2023
|
|
Week day starting on Sunday and not on Monday
|
|
2
|
319
|
November 15, 2022
|
|
Table.NestedJoin vs List
|
|
2
|
374
|
September 21, 2022
|
|
PQ Too many merges - but works in SQL Server
|
|
4
|
387
|
July 22, 2022
|
|
Add a Custom Fiscal Quarter Offset column to a Date table (Power Query M function)
|
|
1
|
697
|
June 5, 2022
|
|
Extended Date table Fiscal Period Offset
|
|
3
|
705
|
June 2, 2022
|
|
Values for data before Period Ends
|
|
4
|
411
|
May 18, 2022
|
|
Basic Date Table (Power Query M function)
|
|
3
|
2909
|
April 20, 2022
|
|
How to expand your knowledge on M?
|
|
12
|
2582
|
April 14, 2022
|
|
Translate M code to SQL code (and vice versa)
|
|
6
|
2800
|
April 5, 2022
|
|
Adding a Last Refresh date to your Report
|
|
22
|
13772
|
February 28, 2022
|
|
Request with M code
|
|
10
|
997
|
February 24, 2022
|
|
I am stuck to convert a formula in excel into m code
|
|
6
|
783
|
February 1, 2022
|
|
New Cheat Sheet for Extended Date Table
|
|
7
|
5657
|
January 13, 2022
|
|
Time Table (Power Query M function)
|
|
5
|
3346
|
November 2, 2021
|
|
Creating a dynamic Start-/EndDate for the Date table
|
|
4
|
6484
|
May 6, 2020
|
|
Dynamic Date Range Slicer- Query M
|
|
26
|
8412
|
March 16, 2021
|
|
Catalogue of all Power Query Functions in PBI
|
|
2
|
1098
|
March 12, 2021
|