Forum Discussion
witbi
Helper I
Helper IExtract parent for child based on ordered list reference
Hello everyone, I have a table that has an ordered list reference which I would like to convert into a flat hierarchy to use in filters. However, I'm stuck on how to extract the parent for each c...
witbi here is the file.
wdx223_Daniel
Community Champion
Community Championwitbi here is the file.
witbiHelper I
Helper IMany thanks wdx223_Daniel. Your approach using a measure is a very nice solution.
However, I'm looking for a calculated column so I can generate the separate columns for each level to use in a slicer.
I opened another question PATH function extract sub-level 2 hierarchy, where I am trying to generate a path hierarchy based on an introduced index. However I'm stuck on that. If you have ideas please do let me know!