Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Anonymous -
Used https://www.daxpatterns.com/parent-child-hierarchies/. Seems to work for me.
Solution = IF ( PATHLENGTH ( PATH ( Table1[Global ID], Table1[Supervisor ID] ) ) = 1, BLANK (), IF ( CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1 ), Table1[Supervisor ID] = EARLIER ( Table1[Global ID] ) ) = 0, "Below Manager", "Manager" ) )
Proud to be a Super User!
@Anonymous -
Used https://www.daxpatterns.com/parent-child-hierarchies/. Seems to work for me.
Solution = IF ( PATHLENGTH ( PATH ( Table1[Global ID], Table1[Supervisor ID] ) ) = 1, BLANK (), IF ( CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1 ), Table1[Supervisor ID] = EARLIER ( Table1[Global ID] ) ) = 0, "Below Manager", "Manager" ) )
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |