Forum Discussion

nick-evans's avatar
nick-evans
Advocate I
8 years ago
Solved

Dealing with PATH Duplicates Errors?

I have a site that is built as a hierarchy.    I am ultimately trying to distinguish if items in that hierarchy, at any point belong to a space with the name of 'Internal', because if so, they get t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • nick-evans's avatar
    nick-evans
    Advocate I
    8 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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