Lookup Function

[New2PowerBI]

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. 

[MarcelBeug · Accepted solution]

You can merge the table with itself as outlined in this video.