Business Intelligence with Microsoft Power BI - with Material - Tricks to Get Help on More than 900 M Functions
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
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.
Read more
2 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
What is the significance of the syntax provided at the bottom when you expand a function in Power Query?
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • 1 pt
How does the number of functions in Power Query differ between Power BI and Excel?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
