Power BI Leader/Manager Chain Query
Budget: $10 – $30 USD
I'm needing go up a management chain to find the leader of a user with 'VP' or 'Vice President' in their job title.
I've got 2 tables titled 'EnabledUsers' and 'AllUsers'.
I get the Leader's title by the following:
LeaderTitle =
Calculate(
FIRSTNONBLANK (EnabledUsers[jobTitle],1 ),
Filter (
ALL (EnabledUsers),
EnabledUsers[username] = AllUsers[leaderUserName]
)
)
If the leader's title contains 'VP', or 'Vice President', then I want to return that specific leader's Name which a column on the AllUsers table named Leader. If that leader's title does NOT contain either of those words, I want to go up a level to that leader's leader, and determine if their title contains either, and continue...
I've got 2 tables titled 'EnabledUsers' and 'AllUsers'.
I get the Leader's title by the following:
LeaderTitle =
Calculate(
FIRSTNONBLANK (EnabledUsers[jobTitle],1 ),
Filter (
ALL (EnabledUsers),
EnabledUsers[username] = AllUsers[leaderUserName]
)
)
If the leader's title contains 'VP', or 'Vice President', then I want to return that specific leader's Name which a column on the AllUsers table named Leader. If that leader's title does NOT contain either of those words, I want to go up a level to that leader's leader, and determine if their title contains either, and continue...