You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: Total Sales
We select the field Total Sales
Box 2: Date
Select a date field.
Box 3: Month
Monthly periods.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures

Comment: *

Name: *

Email: *

Verification: *

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.
You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.
Which report setting should you configure?

• A.Choose the type of data you allow your end users to export.
• B.Change default visual interaction from cross highlighting to cross filtering.
• C.Enable the updated filter pane, and show filters in the visual header for this report.
• D.Allow users to add comments to this report.
• E.Don't allow end user to save filters on this report.

Comment: *

Name: *

Email: *

Verification: *

You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.)

The file is in c:\data\.
You need to ensure that you can publish the file to Power BI.
What should you do first?

• A.Save the file in a Microsoft SharePoint document library.
• B.Decrypt the workbook.
• C.Add a digital signature to the workbook.
• D.Set the file attributes to read-only.

Comment: *

Name: *

Email: *

Verification: *

You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.
How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You are modeling the data in Power BI.
You need to import only a sample of the data from the Order table.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.From Query Editor, add a SELECT statement that uses a WHERE clause to the source definition.
• B.From Query Editor, create a custom column that uses a custom column formula.
• C.In the Power BI model, create a calculated table.
• D.From Query Editor, filter the table by Order_date.
• E.From Query Editor, create a column by using Column From Examples.

Comment: *

Name: *

Email: *

Verification: *