Question 1

What is the first step to create a cumulative total chart in Power BI?

Accepted Answer

Create a new measure.

Answer

Rename the existing date table.

Answer

Use the calculate function.

Answer

Create a new table named

Question 2

How can you ensure the newly created calendar table is connected to the Sales data table?

Accepted Answer

Look for a relationship icon between the two tables.

Answer

Manually enter a formula to connect the two tables.

Answer

There is no need to connect the calendar table to the Sales data table.

Answer

Use the filter expression based on the newly added calendar table.

Question 3

Which of the following DAX functions is used to create a cumulative total calculation?

Accepted Answer

SUMX

Answer

AVERAGEX

Answer

CALCULATE

Answer

COUNTAX

Question 4

What is the purpose of adding the filter expression based on the calendar table to the calculate function?

Accepted Answer

To set a start and end date for the cumulative total.

Answer

To remove duplicate values.

Answer

To filter the dates based on the selected date on the chart.

Answer

To ensure the calculation is based on the latest date.

Question 5

How does the DAX function determine the cumulative total for each date?

Accepted Answer

It adds all the sales amounts up to the current date.

Answer

It subtracts the sales amount from the previous date.

Answer

It calculates the average sales amount for all dates.

Answer

It multiplies the sales amount by the number of days since the start date.

Question 6

What does the line chart with the cumulative total represent?

Accepted Answer

The sum of sales amount up to a specific date.

Answer

The average sales amount for each month.

Answer

The total sales amount for each date.

Answer

The difference in sales amount between consecutive dates.

Question 7

What would the cumulative total line chart look like if real data were used instead of randomly generated data?

Accepted Answer

It would likely show a stair-step pattern.

Answer

It would show a constantly increasing line.

Answer

It would show a straight line.

Answer

It would show a random scatter plot.

Question 8

Why is it important to subscribe to the Essential Excel channel on YouTube?

Accepted Answer

To get notified about new videos on DAX in Power BI.

Answer

To learn the latest updates on Power BI.

Answer

To see more videos about creating charts in Power BI.

Answer

To learn more about Microsoft Excel.

Question 9

What does the underscore "_" at the beginning of the newly created measures table name do?

Accepted Answer

It hides the table from being selected in the report.

Answer

It marks the table as a temporary measure.

Answer

It allows the table to be used in multiple reports.

Answer

It ensures the table appears at the top of the Fields pane.

Question 10

Which of the following is the most appropriate way to describe the video?

Accepted Answer

A step-by-step guide on calculating cumulative totals in Power BI using DAX.

Answer

An introduction to Power BI.

Answer

A tutorial on creating a new table in Power BI.

Answer

An explanation of different chart types in Power BI.

Related quizzes

Related quizzes