Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

13How do you know a field is a measure when selecting from the Field List of a PivotTable? a)Measures are listed all together in the

13How do you know a field is a measure when selecting from the Field List of a PivotTable?
a)Measures are listed all together in the Field List.
b)They are listed in bold in the field list.
c)The are not listed in the field list.
d)They are preceded by an "fx" in the field list.

14 What is the syntax for creating a measure in the Power Pivot data model?
a)Name:=formula/function/expression.
b)=function(argument , argument ,etc.).
c)Name=formula/function/expression.
d)[Name]:=formula/function/expression.

15 When creating a measure, what formula language do you use?
a)DAX (Data Analysis Expressions).
b)Excel Functions.
c)SQL (Sequential Query Language).
d)M Query Language.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

The detailed answer for the above question is provided below Here are the answers to your questions ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Investments, Valuation and Management

Authors: Bradford Jordan, Thomas Miller, Steve Dolvin

8th edition

1259720697, 1259720691, 1260109437, 9781260109436, 978-1259720697

More Books

Students also viewed these Finance questions