EXACT Function

Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. You can use EXACT to test text being entered into a document.

Syntax

EXACT(<text1>,<text2>)

Parameters

Term

Definition

text1

The first text string or column that contains text.

text2

The second text string or column that contains text.

Property Value/Return Value

True or false. (Boolean)

Example

The following formula checks the value of Column1 for the current row against the value of Column2 for the current row, and returns TRUE if they are the same, and returns FALSE if they are different.

=EXACT([Column1],[Column2])

See Also

Other Resources

Text Functions (DAX)