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-biAnswer:
EXCEPTPATH This answer is correct. PATHITEM CROSSJOIN This answer is correct.
0 / 5 Â (0 ratings)
1 answer(s) in total