Lookup value in M Code

I have two queries as per below.  I am trying to do an M code to pull over Employee Title into query B using Employee ID as the unique identifier.  I would need this to be done in M code vs. DAX, ple...