<< Prev Question Next Question >>

Question 25/35

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.
Start of repeated scenario.
You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit. (Click the Exhibit button.) Data Sample exhibit:




The data model is shown in the Data Model exhibit. (Click the Exhibit button.)

The tables in the model contain the following data:
* DailyRepairs has a log of hours and revenue for each day, workshop, and repair type. Every day, a log entry is created for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue column.
* Workshops have a list of all the workshops and the current and previous workshop managers. The format of the Workshop Manager column is always Firstname Lastname. A value of 1 in the IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.
* RepairTypes has a list of all the repair types
* Dates has a list of dates from 2015 to 2018
End of repeated scenario.
To the Dates table, you need to add a calculated column named Months Ago. Months Ago must display the number of calendar months before the current month. For example, if the current date is July 10, 2017, the Value of Months Ago will be 0 for all the dates in July 2017, 1 for all the dates in June 2017, and 2 for all the dates in May 2017.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (35q)
Question 1: You have a table that contains data relating to exam candida...
Question 2: You have the data model shown in the Data Model exhibit. (Cl...
Question 3: You have a date column named [Date] in the format of mm-dd-y...
Question 4: You create a PivotTable and a Pivot Chart as shown in the fo...
Question 5: Note: This question is part of a series of questions that us...
Question 6: Note: This question is part of a series of questions that us...
Question 7: You have a table in Power Pivot model that is loaded from a ...
Question 8: You have a data model in Excel. You export the data and the ...
Question 9: Note: This question is part of a series of questions that us...
Question 10: From a workbook query, you import a table that has the follo...
Question 11: You have a data model that contains a table named SalesOrder...
Question 12: You have a query as shown in the following exhibit. (Exhibit...
Question 13: You have a model that contains data relating to corporate pr...
Question 14: You open an Excel worksheet as shown in the following exhibi...
Question 15: You have a KPI named Goal that calculates the sales from the...
Question 16: You have a table in a Microsoft SQL Server database that has...
Question 17: Note: This question is part of a series of questions that pr...
Question 18: You have a workbook query that uses an Excel data source. Th...
Question 19: Note: This question is part of a series of questions that pr...
Question 20: You have a query that retrieves customers and their location...
Question 21: Note: This question is part of a series of questions that pr...
Question 22: You need to create a combo chart to display the count of ord...
Question 23: You need to create a PivotChart as shown in the exhibit. (Cl...
Question 24: Note: This question is part of a series of questions that pr...
Question 25: Note: This question is part of a series of questions that us...
Question 26: Note: This question is part of a series of questions that pr...
Question 27: You have the following data sample. (Exhibit) You need to cr...
Question 28: You have an Excel workbook that has the following two workbo...
Question 29: You have the PivotTable shown in the following exhibit. (Exh...
Question 30: You have a model that contains data relating to corporate pr...
Question 31: You have 12 sales reports stored in a folder as CSV files. E...
Question 32: You have a model that contains the following table named Sal...
Question 33: You have a table named AnnualSales. A sample of the data in ...
Question 34: You have a measure named SalesGrowth that calculates the per...
Question 35: You need to configure a PivotChart as shown in the following...