Forum Discussion
lionx
Helper I
Helper IFix 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...
HotChilli
Community Champion
Community ChampionAll 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.
lionxHelper I
Helper IThanks 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?