Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
In my employee table, I want to create a new column in DAX that shows the team the employee comes from plus the manager. Like the following example:
How can I based on team and title create column "Team & Manager"?
Thank you in advance 🙂
Solved! Go to Solution.
@Anonymous , Create a new column like
[Team] & " - " & maxx(filter( Table, [team] =earlier([Team]) && [title]="Manager"),[Name])
@Anonymous , Create a new column like
[Team] & " - " & maxx(filter( Table, [team] =earlier([Team]) && [title]="Manager"),[Name])
These should help
https://docs.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-dax
https://www.daxpatterns.com/parent-child-hierarchies/
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |