Forum Discussion
Fix errors for flatten BOM Parent-Child Hierarchy using PATH function
I'm trying to visualize the Bill of Materials dataset in power BI. However, when I use the PATH function to flatten the BOM Parent-Child Hierarchy, it comes up with the error as follows. Any s...
All it's saying is that you need to add the values in the parentid column into the 'no' column (even if they just point at themselves).
That will make the error go away.
Thanks for your suggestion. I did try that and it works for this specific item. But I do not want to change the data structure as it has thousands of records. Any other solutions?