Knowledge check

Completed

1.

Which DAX function can't be used in a visual calculation?

USERELATIONSHIP

AVERAGEX

SUM

2.

What does the Axis parameter of visual calculation functions do?

It defines how the calculation function traverses the visual matrix.

It defines which relationship to use to relate two tables.

It changes your screen from horizontal to vertical layout.

3.

A data analyst is working on a visual calculation in Power BI. They want to compare the current value of a metric to its preceding value. Which template should they use?

Moving average

Running sum

Versus previous

4.

A data analyst is working on a visual calculation and wants to ensure the calculation traverses the visual matrix row by row from top to bottom, then column by column from left to right. Which Axis parameter value should the analyst use?

COLUMNS ROWS

ROWS

ROWS COLUMNS

You must answer all questions before checking your work.