Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Compares two text strings and returns TRUE if they're exactly the same, otherwise returns FALSE. EXACT is case-sensitive but ignores formatting differences.
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. |
Return value
True or False. (Boolean)
Example
The following formula in a calculated column in the Product table checks the value of Product for the current row against the value of Model for the current row. It returns True if they're the same, and False if they're different.
Examples in this article can be used with the sample Adventure Works DW 2020 Power BI Desktop model. To get the model, see DAX sample model.
=
EXACT ( [Product], [Model] )