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 initial step to access all M functions in Power Query?

• Use a predefined function list

• Import data from Excel

• Use a blank query and type '= #shared'

• Create a new table

What is the purpose of converting the list of functions into a table format?

• To print the list

• To create a visual chart

• To easily filter and analyze the functions

• To export the list to a database

How can you identify date functions in Power Query?

• They start with 'date'

• They are highlighted in blue

• They are listed under a separate tab

• They require a special plugin

What information is provided when you click on a function in Power Query?

• Only the function name

• Syntax, explanation, and example

• A video tutorial

• A link to the official documentation

How many M functions are available in Power Query for Excel compared to Power BI?

• It varies depending on the version

• The same number

• More in Power BI

• More in Excel