Business Intelligence with Microsoft Power BI - with Material - Tricks to Get Help on More than 900 M Functions

The video tutorial demonstrates a simple trick to access and explore M functions in Power Query. It guides users on how to create a blank query and use the formula '= #shared' to list available functions. The tutorial covers filtering functions by type, such as date, text, and number functions, and provides examples of how to view syntax and outputs. Additionally, it shows how the same method can be applied in Excel, highlighting differences in the number of available functions between Power BI and Excel.

What is the significance of the syntax provided at the bottom when you expand a function in Power Query?

How does the number of functions in Power Query differ between Power BI and Excel?