
Business Intelligence with Microsoft Power BI - with Material - Basic Date M Functions
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
Read more
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step in setting up a query in Power Query to extract date information?
Load data and duplicate the query
Create a new workbook
Export data to Excel
Delete all previous queries
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which prefix is essential for all M functions related to dates?
month
time
date
day
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you extract the month from a date using M functions?
Use the function date.day
Use the function date.week
Use the function date.month
Use the function date.year
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What feature in newer versions of Power Query helps with function suggestions?
Query Helper
M Intellisense
AutoComplete
Function Wizard
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to get the name of the day from a date?
date.year
date.dayOfWeekName
date.month
date.day
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?
Similar Resources on Wayground
8 questions
Graph axis of symmetry vertex and max and min, domain and range
Interactive video
•
11th Grade - University
8 questions
How do we find multiplicity and use it to graph a polynomial
Interactive video
•
11th Grade - University
6 questions
Finding the rule for a linear function when given a table - How to solve math problems
Interactive video
•
11th Grade - University
6 questions
Domain of rational function with radical in the numerator
Interactive video
•
11th Grade - University
6 questions
Frege and Functions
Interactive video
•
11th Grade - University
6 questions
Wave Function
Interactive video
•
11th Grade - University
6 questions
What is exponential and logarithmic form
Interactive video
•
11th Grade - University
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
Discover more resources for Information Technology (IT)
20 questions
Disney Trivia
Quiz
•
University
7 questions
Fragments, Run-ons, and Complete Sentences
Interactive video
•
4th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
10 questions
DNA Structure and Replication: Crash Course Biology
Interactive video
•
11th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
14 questions
Ch.3_TEACHER-led
Quiz
•
University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University