Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Here is my challenge:
I have the following, all in one Table:
Person ID DISPLAYNAME SUPERVISOR
123 Jane Doe 456
456 John Fort 789
789 Bill Will 159
...etc...
I have other values in the table, but I think I need to focus on these.
How can I create a column that displays the Supervisor's DISPLAYNAME? So instead of just seeing "456" as the Supervisor, I could see "John Fort" as a new column (SUPERVISORDISPLAYNAME).
Very new to Power BI and functions in general; looking forward to learning.
Solved! Go to Solution.
You can merge the table with itself as outlined in this video.
You can merge the table with itself as outlined in this video.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |