Forum Discussion
Matching values then performing lookup
After importing your two separate tables, create a relationship joining emailaddress from the CSV file with your HR data.
Then in your table visual or other visual, the sAMAAccontName will be available to display.
If you wanted, you can use the LOOKUPVALUE function to populate your HR data with the sAMA value.
Hope this gets you going in the right direction.
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.