This Power BI Online Test
Separates Good From Bad Hires

A Power BI report for a model which has the Country, Sales, and Product fields should show the following bar chart:

Select all the things that need to be done to recreate the chart above.

​A business owner needs a Power BI report which shows the projected quantity for each item. The "quantity" column is in the "items" table.

Fill in the blank of the following DAX expression for a new column that will compute the projected quantity, which is the current quantity plus 12%: 

Projected Quantity = ______________ * 1.12

As an entry-level financial analyst, your manager asked you to analyze the prices of a new stock and make a buy-sell recommendation. Daily price trends seems to fluctuate as can be seen below:

You need to create a new measure which will create a rolling average for 7-day periods, as below, because an increasing trend in a rolling average may signal an increase in the price of the stock.

How should you configure the quick measure, shown below, for the rolling average for the last 7 days?

A Power BI report has a measure declared as:

Profit percentage = SUM(financials[Profit]) / CALCULATE(SUM(financials[Profit]), ALL(financials))

Select all the true statements if the "Profit percentage" is used as a value in a bar chart where Country is the axis.