PL-300 Question 112

Question

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])

Accepted Answer

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

PL-300 Question 112

Community Discussion

Preparing Practice Exam…

PL-300 Question 112

Community Discussion