Forum Discussion
Matching values then performing lookup
I have a dashboard that contains employee information (name, e-mail, etc.) that is pulled from our HR system. I have been asked to add the users' sAMAccountName from Active Directory to the dashboard...
Sounds like you need to be creating a relationship from your CSV to the HR data. Use the e-mail to relate the 2 tables, should be one to many although it could be one to one depending what your HR data looks like.
It was a late night and once I looked at my problem from a different angle I decided to go a different route since it was a quick fix and considering I only update the data once a month not worth (yet) trying to get it to work in PowerBI.
I just copied the 2 columns containing the e-mail and networkID into a new tab of the HR spreadsheet then used vLookup to add the Network ID. Once I refreshed my dashboard I just added the column to visual on my dashboard and it gave me what I needed.