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())

Community Additions

ADD
Show:
© 2014 Microsoft