Table of contents
TOC
Collapse the table of content
Expand the table of content

EXACT Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

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

TermDefinition
text1The first text string or column that contains text.
text2The 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

Text Functions (DAX)

© 2018 Microsoft