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.