Question 41

You have a Power B1 report that contains the fields shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Question 42

You have a semantic model that contains a table named Sales. The table contains the following columns;
* Order ID
* Product ID
* Sales Dote
* Sales Amount
You need to create a DAX measure that will return the total sales amount for the same dates from the previous ye ar. How should you complete the measure? To answer, select the appropriate options m the answer area.
NOTE: Each correct selection is worth one point.

Question 43

You need to create a visualization to meet the reporting requirements of the sales managers.
HOW Should create the Visualization? TO answer, select the appropriate options in the answer are a.

Question 44

The data model must support the following analysis:
* Total sales by product by month in which the order was placed
* Quantities sold by product by day on which the order was placed
* Number Of sales transactions by quarter in Which the order was placed For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.

Question 45

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales You need to create a measure that calculates the total sales from the equivalent month of the previous year.
How should you complete the calculation? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.