Forum Discussion
Dealing with PATH Duplicates Errors?
Through a PM, this was the recommendation:
In your sceanrio, a child(SpaceName) may have multiple parents(ParentName), please follow the guide in the following blogs to solve this multi-parent-hierarchies issue.
http://www.thebiccountant.com/2017/02/14/dynamically-flatten-parent-child-hierarchies-in-dax-and-pow...
http://www.thebiccountant.com/2017/05/08/dynamic-bill-of-material-bom-solution-in-excel-and-powerbi/
nick-evans,
I note that you post another similar thread which has been solved by creating the following column, does the column return your expected result?
Path = PATH(Table1[SpaceName], Table1[ParentName])
Regards,
Lydia
Hi Lydia,
Unfortunately it does not.
In my sample data (which is what was being tested in the other thread) it works.
However in my production data there are duplicates which present the various errors I outlined in this thread.
nick-evans,
What version of Power BI Desktop do you use? Could you please share the working PBIX file and the problem PBIX file for me to test? You can upload PBIX files to OneDrive and send me shared link of the files via Private Message.
Regards,
Lydia