Conditional column evaluation on grouped data to maintain a distinct list

Hello,   Using PowerBI I am trying to use Active Directory as the source of user information for our mobile phone accounts because the data in the mobile environment has gotten way out of sync and ...