Power Query

M Code Showcase Ask questions and share knowledge about Power BI Showcase related to M Code Data Setup Everything you need to know about structuring your data when completing Power BI reports

Topic	Replies	Views	Activity
About the Power Query category Power Query	1	2048	November 12, 2019
Power Query - Multiple excel sheets in one file Power Query	5	53	October 7, 2025
Power Query - connect to Dataset Tables M Code Showcase	1	709	September 19, 2025
Extended Date Table (Power Query M function) M Code Showcase	230	121929	September 11, 2025
Recursive calculation Food supply Power Query	9	96	August 29, 2025
Unpivoting multiple alternate rows M Code Showcase	7	82	August 11, 2025
Replace blanks in dataset - best practice? Power Query	2	237	July 2, 2025
Extended Date Table with 4-4-5 fiscal model M Code Showcase	2	80	June 23, 2025
Transform a table Data Setup	2	126	March 6, 2025
Retain ability to join after reshaping dimension tables Power Query	4	86	March 5, 2025
Get transformation rules from a Mapping table Power Query	6	114	February 13, 2025
Data Structure Reshaping Challenge Power Query	3	97	February 4, 2025
Two new columns different positions Power Query	11	163	January 21, 2025
How to connect Magento ecommerce database with Power BI Data Setup	8	1626	January 15, 2025
Data Extraction & Storage Data Setup	6	1558	December 13, 2024
Transform PDF Journal Entry to an excel file in Powerquery M Code Showcase	18	186	December 10, 2024
Disable background refreshes? Power Query	2	374	December 8, 2024
PQ displaying 0 or 1 rather than true or false Power Query	3	102	November 26, 2024
Test Filters in M Code M Code Showcase	2	123	November 25, 2024
Extended Date Table Power Query	10	1823	November 1, 2024
How to achieve this data view from the given report Power Query	1	76	October 31, 2024
ODBC connection error Power Query	2	195	October 24, 2024
Transform data which has multiple columns with the same name but different values Power Query	2	118	October 21, 2024
Finding the first and last rows in a non contiguous list M Code Showcase	3	93	October 8, 2024
Best Practice for Handling Period Based Data in Fact Tables Data Setup	2	203	September 16, 2024
Where to store source data? Data Setup	3	838	September 11, 2024
Lookup a Value in a different table and return a value from another column M Code Showcase	1	119	August 27, 2024
Geospatial Functions M Code Showcase	1	127	August 20, 2024
Determine a lookup key or match for another table M Code Showcase	1	69	August 20, 2024
Fill in Records for Missing Dates Data Setup	1	89	August 18, 2024