EXACT

Applies to: Calculated column Calculated table Measure Visual calculation

Compares two text strings and returns TRUE if they are exactly the same, otherwise returns FALSE. EXACT is case-sensitive but ignores formatting differences. EXACT is case-sensitive

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 used 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, and returns True if they are the same, and returns False if they are 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])  

Text functions