Power BI Online Test

Sales team has asked you to create a Power BI report which shows the following bar chart:​​

Select all the things that need to be done to create 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

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.

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?