I have this data above. I want to create a new column which checks any values in Global ID and compares it with Supervisor ID. So, If any number in supervisor ID contains Global ID, return Manager else Below Manager. The output should be like this.
Go to Solution.
Used https://www.daxpatterns.com/parent-child-hierarchies/. Seems to work for me.
PATHLENGTH ( PATH ( Table1[Global ID], Table1[Supervisor ID] ) ) = 1,
COUNTROWS ( Table1 ),
ALL ( Table1 ),
Table1[Supervisor ID] = EARLIER ( Table1[Global ID] )
) = 0,
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.