Forum Discussion

witbi's avatar
witbi
Icon for Helper I rankHelper I
5 years ago
Solved

Extract 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...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Create your lists in Power Query, using pipe "|" as the concatenator. Then in DAX you can use PATHITEM etc functions.

witbi's avatar
witbi
Icon for Helper I rankHelper I
5 years ago

Thanks @lbendlin. I have opened another question PATH function extract sub-level 2 hierarchy to look at this approach. wdx223_Daniel 's measure solution may well help others so I've accepted his solution and will progress your suggested approach on the other question.