You have a Power Bl report that contains a measure named Total Sales. You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You are creating an analytics report that will consume data from the tables shown in the following table

You have a Power Bl report named Orders that supports the following analysis:
• Total sales over time
• The count of orders over time
• New and repeat customer counts
The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.

You have sales data in a star schema that contains four tables named Sales, Customer,
Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the
data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must
minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.)
The data has the following refresh requirements:
• Customer must be refreshed daily.
• Date must be refreshed once every three years.
• Sales must be refreshed in near real time.
• SalesAggregate must be refreshed once per week.
You need to select the storage modes for the tables. The solution must meet the following requirements:

You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?

You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection. You need to ensure that users can use Q&A from the Power BI service for the dataset. What should you do?

You have the visual shown in the Original exhibit. {Click the Original tab.)


What should you add to the visual?