I try to create a hirarchy with the Dax-Formula =PATH(Child;Parent) [the german version requires a ; insted of ,]
for the balance sheet.
The error message tells that a certain value (3 Gewinnruecklage) of the Child column refers to more then one value in the parent column.
When I filter the Child column for the certain value in PowerPivot or in SSMS I just find one dataset. So there is just one value.
What could I do to solve this error? When I delete the certain value, I get the same error with another value.
(The PATH-Formula work in another Dimension of the same PowerPivot)
How many letters may a value contain? I use up to 120 letters.