PdfPrep.com

What should you do?

You need to ensure that the Sales measure in the Power View field list meets the requirements.

What should you do? (Each correct answer presents a part of the solution. Choose all that apply.)
A . Format the column to display zero decimal places.
B . Hide the column from client tools.
C . Create a measure named Sales based on the column by using the Data Analysis Expressions (DAX) SUM () function.
D . Rename the column to Sales.
E . Format the measure to display zero decimal places.

Answer: A, C

Explanation:

* Data Analysis Expressions (DAX) provides many functions for creating aggregations such as sums, counts, and averages. These functions are very similar to aggregation functions used by Microsoft Excel.

* SUMX Function

Returns the sum of an expression evaluated for each row in a table.

Exit mobile version