M Code Let Expressions Quiz

False (B)

null

<p>comma</p> Signup and view all the answers

<p>let expression = A structure to define variables and calculations in M Code null value = Represents the absence of a value in M Code logical value = A value that can either be true or false identifier = A name that represents a specific value or expression</p> Signup and view all the answers

<p>in (D)</p> Signup and view all the answers

<p>True (A)</p> Signup and view all the answers

<p>/* comment */</p> Signup and view all the answers

<p>Power Query (B)</p> Signup and view all the answers

<p>False (B)</p> Signup and view all the answers

<p>M Code</p> Signup and view all the answers

<p>Mashup</p> Signup and view all the answers

<p>Power Query = Data transformation and loading Power BI Desktop = Reporting and data visualization Excel = Data analysis with worksheets Data Model DAX = Advanced analytics and calculations</p> Signup and view all the answers

<p>Case-sensitive, function-based language (C)</p> Signup and view all the answers

<p>False (B)</p> Signup and view all the answers

<p>2015</p> Signup and view all the answers

<p>An error will be raised. (A)</p> Signup and view all the answers

<p>True (A)</p> Signup and view all the answers

<p>Windows-1252, ANSI Latin 1; Western European (Windows)</p> Signup and view all the answers

<p>error</p> Signup and view all the answers

<p>One to five (C)</p> Signup and view all the answers

<p>UTF-7 = 65000 UTF-8 = 65001 Windows-1252 = 1252 IBM865 = 865</p> Signup and view all the answers

<p>False (B)</p> Signup and view all the answers

<p>#(tab)</p> Signup and view all the answers

<p>To convert a text file containing a specified delimiter into a table (B)</p> Signup and view all the answers

<p>False (B)</p> Signup and view all the answers

<p>csv or txt</p> Signup and view all the answers

<p>columns</p> Signup and view all the answers

<p>source = The text file to be converted columns = Specifies which columns to import delimiter = Defines the character used to separate values extraValues = Determines what happens to skipped columns</p> Signup and view all the answers

<p>Period (D)</p> Signup and view all the answers

<p>False (B)</p> Signup and view all the answers

<p>All columns are imported</p> Signup and view all the answers

<p>A duration value (B)</p> Signup and view all the answers

<p>False (B)</p> Signup and view all the answers

<p>#time(hour, minute, seconds)</p> Signup and view all the answers

<p>1/1/0001</p> Signup and view all the answers

<p>#date(year, month, day) = Creates a date value #time(hour, minute, seconds) = Creates a time value #datetime(year, month, day, hour, minute, seconds) = Creates a datetime value #duration(days, hours, minutes, seconds) = Creates a duration value</p> Signup and view all the answers

<p>Time values can be offset using addition and subtraction. (A)</p> Signup and view all the answers

<p>True (A)</p> Signup and view all the answers

<p>Addition and subtraction</p> Signup and view all the answers

<p>It combines data from multiple tables while keeping all records from the left table. (D)</p> Signup and view all the answers

<p>False (B)</p> Signup and view all the answers

<p>=&gt;</p> Signup and view all the answers

<p>custom function</p> Signup and view all the answers

<p>They return records from the left table that do not have corresponding records in the right table. (C)</p> Signup and view all the answers

<p>Variable Names = Defined using identifiers without spaces Go To Operator = Indicates the start of the variable mapping Value Types = Optional definitions for variable types Comments = Used to add non-executable notes in the code</p> Signup and view all the answers

<p>False (B)</p> Signup and view all the answers

<p>// or multiple hard returns</p> Signup and view all the answers

<p>common</p> Signup and view all the answers

A Microsoft tool that allows you to connect to, import, clean, transform, and load data, empowering you to create queries for various data sources.

A programming language used to create Power Query queries, named after the 'Mashup Data' functionality it provides.

The ability to combine data from different sources to create a unified view for analysis.

A visual tool in Excel, Power BI Desktop, and the Power BI Online Service (as Dataflow) that allows you to create Power Query queries through a graphical interface.

Powerful formulas used in Excel and Power BI to perform calculations, analytics, and data analysis.

Interactive tables that allow you to summarize and analyze data by dragging columns and rows.

Formulas specific to the Data Model in Excel and Power BI, used for advanced analytics and calculations.

A function-based language that works with M Code, worksheet formulas, and Data Model DAX formulas to provide a consistent approach to data analysis and manipulation.

In M Code, a date value is represented as an integer representing the number of days since 1/1/0001.

M Code represents time values as a decimal number between 0 and 1. Where 0 is midnight and 1 is the end of the day.

M Code represents datetime values as a serial number representing the number of days since 1/1/0001 (integer part) plus a decimal number representing the proportion of a 24 hour day.

To create a datetime value in M Code, use the join operator '&' and combine a date value with a time value. For example: #date(2023, 1, 1) & #time(12 , 30, 0)

The #date(year, month, day) intrinsic function in M Code returns a date value.

The #time(hour, minute, second) intrinsic function in M Code returns a time value.

The #datetime(year, month, day, hour, minute, second) intrinsic function in M Code returns a datetime value.

Time values in M Code can be subjected to mathematical operations like addition and subtraction in order to adjust them. Time values can also be compared using operators like '<', '>' or '='.

A let expression in Power Query is a way to define and reuse variables within your query. It helps organize your steps and makes your code more readable. Each variable represents a specific query step, and you can use these variables later in the query to easily reference the results.

The let expression starts with the keyword "let" followed by the variables you want to define. Each variable is assigned a value using an equal sign ("="). Separate variables by commas, and end the let expression with the keyword "in" followed by the variable or expression you want to return as the result of the query.

The let expression allows you to break down a complex query into smaller, more manageable steps. By defining variables, you can create a clear and logical flow for your query, making it easier to understand and modify later.

A null value in Power Query represents the absence of a value. It is often used to indicate that data is missing or not available.

In Power Query, logical values are represented by the Boolean values "true" or "false". These values are used in conditional statements to dictate the flow of your queries. For example, you might check if a certain condition is "true" and then perform a specific action if it is.

Power Query allows you to comment your code using double forward slashes ("//") for single-line comments or using a multi-line comment block that starts with /* and ends with */. Comments are very important for explaining complex code and making your queries easier to understand by other users or even yourself later.

The let statement can be used to create intermediate values, such as tables, which can be used in other parts of the query. This gives you a way to break down large, complex queries into smaller, more manageable steps.

The let expression can be used to create reusable query steps, which can be used in other queries. This makes your code more modular and easier to maintain.

A type of join in data manipulation, in which all rows from the left table are included, and matching rows from the right table are joined based on a common key. Any unmatched rows from the right table are represented with null values.

A function value, often called a custom function in M code, allows you to create a function that defines variables and their mapping to deliver a value. It's similar to Excel's LAMBDA function.

A syntax rule in M code for creating custom functions. Variables are defined with names separated by commas within parentheses. The go to operator (=>) marks the start of the mapping, which is the formula to be executed.

In the function-expression syntax, these names allow you to define variables and their mapping for a custom function.

The = and > symbols form the go to operator (=>), which separates the variable definitions and the formula to be executed in a custom function.

The formula or M code that is to be executed based on the defined variables. It is the main part of a custom function, determining the output.

An identifier that defines the value type of a variable in a custom function. It's optional and helps with type checking.

A comment in M code. It starts with // for a single-line comment or with . for multi-line comments.

A Power Query function that converts text files into tables, defaulting to comma as a delimiter and allowing for customization of delimiters and columns.

The Csv.Document function allows you to specify which columns to import from a text file, choosing 'null' (all columns), a number of columns, a list of names, a table format, or a record.

When the 'columns' argument is omitted or set to 'null', the Csv.Document function infers the number of columns each time the file is refreshed, adapting to potential changes in data.

The 'extraValues' argument in Csv.Document is used in conjunction with the 'columns' argument to determine what to do with skipped columns. It can't be used on its own.

The 'delimiter' argument in Csv.Document specifies the character(s) used to separate data items in the text file, allowing for various delimiters like commas, tabs, carriage returns, and linefeeds.

You can use specific M code commands to specify delimiter characters in the 'delimiter' argument of the Csv.Document function, like "#(cr)" for carriage return and "#(tab)" for tab.

When creating a query in Power Query, if the query output is a table, you can prevent it from being included in the final output by adding a line of M code to filter out the query name. This avoids the table from being added to the worksheet.

An alternative to loading an append table to a worksheet, you can load it into a PivotTable cache. This allows you to use the table for calculations and visualization without adding it to the worksheet.

Specifies how extra columns returned by the splitter function are handled when importing data.

Specifies the text encoding type used for importing data. Common examples include UTF-8, ANSI, and Japanese (Mac).

A record that allows you to define parameters for importing text files, including delimiter, column count, encoding, quote style, and CSV style.

Defines how quoted line breaks are treated during data import.

Specifies the style for importing comma-separated values (CSV) data.

Indicates that quoted line breaks should be ignored.

A delimiter used for separating data values within a text file.

Specifies the number of columns to import from a text file. Omitting this argument allows for flexible column counts.