Posts filed under Power Query

Listing all Functions in the Power Query Editor

Video by: Reid Havens

One of the hurdles with writing M code in Power Query is knowing which functions to use, or which are available. Learn about an easy way to access the entire current list of available functions in the query editor with this simple technique. Plus have access to a Power BI file I created which contains all functions and their related metadata, organized into a report.

Related Article: The Great Function Project: Part 3 - by Mat Herring

Posted on January 15, 2019 and filed under Beginner, Power Query, Power BI.

Power BI Nested Date Sorting by Group Custom Column

Video by: Reid Havens

Power BI doesn't provide any native ways to created a nested sort order on tables. In this video learn how to create a nested date sort order column in the power query editor. Also learn how to use that as a hidden column in either table types in Power BI to create a custom sort order.

Posted on December 14, 2018 and filed under Intermediate, Power Query.

Extracting Multiple Tables From A Power Query Combine Folder Source

Video by: Reid Havens

One of the amazing data connectors in Power Query is the ability to combine files from a folder. However, what happens when those files each contain multiple tables you'd want to combine? This video covers a simple technique to extract multiple tables from each file, using the folder combine data connector.

Posted on December 4, 2018 and filed under Intermediate, Power BI, Power Query.