USERNAME

USERNAME is a DAX function that returns the domain name and user name of the current connection in the format domain-nameuser-name.

Syntax

USERNAME( )

Return Values

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

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

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

Related functions

Other functions related to USERNAME are:

• CUSTOMDATA
• USERCULTURE
• USEROBJECTID
• USERPRINCIPALNAME

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/username-function-dax