EXACT DAX Function (Text)

Syntax  |  Return values  |  Remarks  |  Examples  

Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.

Syntax

EXACT ( <Text1>, <Text2> )

Parameter	Attributes	Description
Text1		The first text string.
Text2		The second text string.

Return values

Scalar A single boolean value.

Remarks

An empty string and BLANK are considered the same value.

Examples

--  EXACT performs string comparison in a case-sensitive way
--  By default, DAX is not case sensitive in comparison. 
--  EXACT can be useful to force case-sensitivity.
DEFINE
VAR A = "sqlbi"
VAR B = "SQLBI"
EVALUATE
    {
        ( "A = B", A = B ),
        ( "EXACT ( A, B )", EXACT ( A, B ) )
    }

Value1	Value2
A = B	true
EXACT ( A, B )	false

Last update: Nov 28, 2023   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/exact-function-dax