SEARCH
You are in browse mode. You must login to use MEMORY

   Log in to start


From course:

POWER BI [PI-300]

» Start this Course
(Practice similar questions for free)
Question:

You have a Power BI Desktop dataset that includes a table named Employees containing a row for each employee with the following columns:Employee IDEmployee NameManager IDManager NameYou need to flatten the parent-child hierarchy in the Employees table by adding an extra column that will contain a listing of employee IDs for all direct and indirect managers of each employee.Which two Data Analysis Expression (DAX) functions should you use? Each correct answer presents part of the solution. PATHITEM CROSSJOIN PATHCROSSJOIN EXCEPT PATHITEM EXCEPTPATH RELATED

Author: da-bi



Answer:

EXCEPTPATH This answer is correct. PATHITEM CROSSJOIN This answer is correct.


0 / 5  (0 ratings)

1 answer(s) in total

Author

da-bi
da-bi