Introduction to Writing DAX formulas

Question 1

What is the meaning of DAX?

Answer 1

Data Analysis Expressions

Question 2

What three types of calculations can be added to your semantic model through DAX?

Answer 2

Calculated Tables
Calculated Columns
Measures

Question 3

Calculated Table formula can _____ or ______

Answer 3

Duplicate or transform existing model data
Create a series of data to produce a new table.

Question 4

Calculated table data is always imported into your model, so it increases the model storage size and can prolong data refresh time.

Answer 4

True

Question 4

A calculated table can’t connect to external data; you need to use ______ to accomplish that task.

Answer 4

Power Query

Question 5

Calculated tables can be useful in various scenarios:

Answer 5

Date tables
Role-playing dimensions
What-if analysis

Question 6

____________ are required to apply special time filters known as time intelligence.

Answer 6

Data Tables

Question 7

DAX time intelligence functions only work correctly when a date table is set up.

Answer 7

True

Question 8

When your source data doesn’t include a date table, you can create one as calculated tables by using the ________ or ________ DAX functions.

Answer 8

CALENDAR or CALENDARAUTO

Question 9

When two model tables have multiple relationships?

Answer 9

Role-playing dimensions

Question 10

Microsoft Power BI models only allow ____ active relationship between tables, which in the model diagram is indicated as a _______.

Answer 10

One, solid line

Question 11

The active relationship is used by default to _______.

Answer 11

Propagate filters

Question 12

Any remaining relationships between the two tables are ________.

Answer 12

inactive

Question 13

Inactive relationships are only used when they’re expressly requested in a calculated formula by using the ___________ DAX function.

Answer 13

USERELATIONSHIP

Question 14

Allow report users to select or filter by values that are stored in the calculated table.

Answer 14

What-if parameters

Question 15

What-if calculated tables are sometimes called __________.

Answer 15

disconnected tables

Question 16

The formula is evaluated for each table row and it returns a single value.

Answer 16

Calculated Columns

Question 17

The formula is concerned with achieving summarization over model data.

Answer 17

Measures

Question 18

Similar to a calculated column, the formula must return a single value.

Answer 18

Measures

Question 19

Unlike calculated columns, which are evaluated at data refresh time, measures are ______________. Their results are never stored in the model.

Answer 19

evaluated at query time

Question 20

Measures can be describe as ________ and _______ measures

Answer 20

Explicit and Implicit

Question 21

Columns that can be summarized by visuals in simplistic ways, like count, sum, minimum, maximum, and so on.

Answer 21

Implicit measures

Question 22

Model calculations that are written in DAX and are commonly referred to as simply measures.

Answer 22

Explicit