Questions
- What is the purpose of M in Power BI and Power Query?
- Formatting cell-level data
- Transforming entire columns or tables
- Creating calculated tables
- Sorting individual cells
- What keyword marks the beginning of a new M variable declaration block?
Start
Let
let
Define
- How is a data source typically connected using M?
- Through the Connection tab
- Via the Import button
- Using a variable, often named
Source
- By applying filters
- What does the
#
symbol represent in M?- The next step in the query
- A step/identifier that includes a space or special characters
- Previous steps in a query
- An intermediate step
- Which function is used to convert extracted text into a numeric value in M?
Text.Extract
Number.From
Transform.Text
Numeric.Convert