Which of the following is not true of a hierarchy in an Excel Data Model?
A) Only one hierarchy per table is allowed.For example,it wouldn't be possible to create the hierarchy Continent,Country,Region,City and the hierarchy Continent,Country,State/Province,City,Zip based on a Geography table.
B) A hierarchy must be created in the Power Pivot window.
C) A hierarchy is often aided by DAX's RELATED function,so that fields from related tables can be brought into a single table and used in building the hierarchy.
D) A hierarchy's main use is to allow users to drill down through the hierarchy in a pivot table.
Correct Answer:
Verified
Q47: Which of the following is true of
Q48: Which of the following most accurately explains
Q49: Which of the following is not true
Q50: Which is true of an Excel Data
Q51: Which of the following is true of
Q53: The DAX function RELATED is used for
Q54: Which of the following is true?
A)You can
Q55: Which of the following is true of
Q56: Which of the following is not a
Q57: In terms of importing data from a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents