|
About the M Code Showcase category
|
|
1
|
1695
|
March 11, 2020
|
|
New Cheat Sheet for Extended Date Table
|
|
8
|
6649
|
December 11, 2023
|
|
Extended Date Table (Power Query M function)
|
|
221
|
91293
|
November 16, 2023
|
|
Power Query varying column names
|
|
1
|
102
|
November 13, 2023
|
|
Adding a column from one table based on a value in a second table
|
|
1
|
98
|
November 9, 2023
|
|
Data in column group format
|
|
7
|
250
|
October 21, 2023
|
|
Interpolate using Power Query
|
|
5
|
261
|
October 16, 2023
|
|
How to Dynamically change the Power Query Steps for the New File name
|
|
2
|
214
|
October 5, 2023
|
|
Create cost cards, each product with own column and cost associated
|
|
5
|
203
|
September 30, 2023
|
|
Combining Bi-Monthly reports to month wise (SAP -ME2J)
|
|
1
|
261
|
September 28, 2023
|
|
Multiply & add 2 columns that are in Tables
|
|
4
|
222
|
September 26, 2023
|
|
Dimension Table
|
|
6
|
372
|
September 23, 2023
|
|
Reply: Split a single row into multiple rows based on multiple colums
|
|
10
|
265
|
September 12, 2023
|
|
Power Query - connect to Dataset Tables
|
|
0
|
236
|
September 5, 2023
|
|
Extended Date Table: Day of Year
|
|
3
|
299
|
August 22, 2023
|
|
Variance of Year calculation in Power Query
|
|
1
|
304
|
August 10, 2023
|
|
Month offset for company start and end date
|
|
7
|
292
|
August 3, 2023
|
|
Triangular Warning Icons
|
|
0
|
232
|
August 1, 2023
|
|
Creating the next 30/60/90/120.... day column in Power BI
|
|
4
|
265
|
July 31, 2023
|
|
Custom Fiscal Month Start Date
|
|
11
|
472
|
July 13, 2023
|
|
Summing specific Columns from table and dynamic renaming new added column
|
|
2
|
316
|
July 3, 2023
|
|
Power Query Post Request Graph API
|
|
3
|
494
|
June 14, 2023
|
|
Covert multiple Column Groups to Rows
|
|
5
|
341
|
June 14, 2023
|
|
Date Format Issue in Power query
|
|
7
|
1618
|
May 29, 2023
|
|
Sort by Chart of Accounts
|
|
7
|
315
|
May 28, 2023
|
|
Find nearest date for a row, same customer, same table?
|
|
12
|
464
|
May 18, 2023
|
|
Expand data after a table merge with conditionals
|
|
5
|
362
|
May 12, 2023
|
|
Power Query - create table
|
|
5
|
569
|
April 20, 2023
|
|
Creating Calendar with Week & Month Cutoff
|
|
2
|
437
|
April 13, 2023
|
|
Conditional merging two tables with New rows
|
|
6
|
402
|
April 10, 2023
|