EXACT DAX Function (Text)
Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.
Syntax
Parameter | Attributes | Description |
---|---|---|
Text1 |
The first text string. |
|
Text2 |
The second text string. |
Return values
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: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/exact-function-dax