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…

You have a measure named SalesGrowth that calculates the percent of sales growth. The measure uses the following formula. ([Total Sales Current Year] – [Total Sales Last year]) / [Total Sales Last Year] Total Sales Current Year is a measure…

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…

You have a measure that is used by a KPI. You need to display the output of the measure in a cell in your workbook. Which Excel function should you use? A. CUBEVALUE B. LOOKUP C. VLOOKUP D. CUBESET

You have the data model shown in the exhibit. (Click the Exhibit tab.) You need to create a hierarchy from DimproductSubcategory[ProductSubcategoryName] and DimProduct[ProductName]. What should you do before you create the hierarchy? A. Create a relationship between the tables. To…

You are building a KPI. You need to configure the KPI to display a red icon when the sales from a month is less than nine percent of the sales from the last 12 months. What should you use to…

You have a table in a Microsoft SQL Server database that has more than 5 columns. A sample of the data and some of the columns are shown in the following table. The table contains more than two million rows.…

You have a Power Pivot data model that contains a table named DimProduct. DimProduct has seven columns named ProductKey, ProductLabel, ProductName, ProductDescription, ProductSubCategoryKey, Manufacturer, and Brand. Only the members of the product team use all the data in the DimProduct…

You have a workbook query that gets a table from an Excel workbook. The table contains a column named Column1. In the query, you configure Column1 to use a Data Type of Whole Number. You refresh the data and find…

You have an Excel workbook that contains a table named Sales. You add Sales to the Power Pivot model. You need to set a column named TransactionID as the row identifier for the Sales table. What should you do? A.…