Assign UserPrincipalName and ID

[Anonymous]

Dear All,

Im trying to create a measure that assigns matches the current userprincipalname with an ID table and returns the ID instead of the UserPrincipleName.

Anyone has any tips? 

Kind regards & thank you

[vojtechsima · Accepted solution]

Hi, @Anonymous 
depends on the exact structure of your model, but maybe a simple MAXX function can do it for you:

getID = 
var currentPrincipal = USERPRINCIPALNAME()
return MAXX(FILTER('IDs', 'IDs'[email] = currentPrincipal), IDs[ID])

[Anonymous · Accepted solution]

Thank you, worked good

[vojtechsima · Accepted solution]

Hi, @Anonymous 
depends on the exact structure of your model, but maybe a simple MAXX function can do it for you:

getID = 
var currentPrincipal = USERPRINCIPALNAME()
return MAXX(FILTER('IDs', 'IDs'[email] = currentPrincipal), IDs[ID])