Forum Discussion
jhartranft60
Advocate IV
Advocate IVPATH function error
I'm attempting to build a quarterly hierarchy. I'm creating this to track our yearly performance appraisal requirements, so the hierarchy is used for both row-level security as well as rolling up...
FYI that you likely need to address the distinct parent issue, but you can use the Bonus Function at the end of this article to perform the equivalent of the PATH function in your query (and it doesn't have the single parent limitation).
Guest Post: Using List.Accumulate for Input/Output Genealogy – The BIccountant
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeFYI that you likely need to address the distinct parent issue, but you can use the Bonus Function at the end of this article to perform the equivalent of the PATH function in your query (and it doesn't have the single parent limitation).
Guest Post: Using List.Accumulate for Input/Output Genealogy – The BIccountant
Pat