Export (0) Print
Expand All

USERNAME Function (DAX)

Returns the domain name and username from the credentials given to the system at connection time

USERNAME()

The username from the credentials given to the system at connection time

Under Windows authentication, the returned string has the structure: <domain-name>\<user-name>

The following code verifies if the user login is part of the UsersTable.

=IF(CONTAINS(UsersTable,UsersTable[login], USERNAME()), "Allowed", BLANK())

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft