Forum Discussion

MalyMajo's avatar
MalyMajo
Frequent Visitor
4 years ago

AD group and resource hierarchy

Hello all,   I have tabular data, which includes list of resources and the groups to which they belong. Is it possible to format the data somehow to always show the structure when a resources is f...
Need Help
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi MalyMajo ,

 

To filter like this in Power Query, you would do the following:

Table.SelectRows(
    previousStep,
    each [Value] = "tony.hawk" or Text.Contains([Value], "ProjectName")
)

 

Pete

  • MalyMajo's avatar
    MalyMajo
    Frequent Visitor
    4 years ago

    Actually, the project name never contains "ProjectName", it was just an example.

    What I want to achieve is to see the hierarchy. So if I filter Tony Hawk, I want to see under which hierarchy he belongs.