You have a Power BI model that contains a table named Employee. The table contains the following data. Each employee has one manager as shown in the ParentEmployeeID column. All reporting paths lead to the CEO at the top of the organizational hierarchy. You need to create a calculated column that returns the count of levels from each employee to the CEO. Which DAX expression should you use?

Questions › Category: PL-300 › You have a Power BI model that contains a table named Employee. The table contains the following data. Each employee has one manager as shown in the ParentEmployeeID column. All reporting paths lead to the CEO at the top of the organizational hierarchy. You need to create a calculated column that returns the count of levels from each employee to the CEO. Which DAX expression should you use?

0 Vote Up Vote Down

Admin Staff asked 4 months ago

You have a Power BI model that contains a table named Employee. The table contains the following data.
 
Each employee has one manager as shown in the ParentEmployeeID column.
All reporting paths lead to the CEO at the top of the organizational hierarchy.
You need to create a calculated column that returns the count of levels from each employee to the CEO.
Which DAX expression should you use?

A. PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))

B. PATHITEM(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1,INTEGER)

C. PATHCONTAINS(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1)

D. PATH(Employee[EmployeeID],Employee[ParentEmployeeID])








 

Suggested Answer: A



This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.