EXACT Function (DAX)

How does the EXACT function (DAX) work?

The EXACT function (DAX) compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences.

EXACT Formula Syntax

EXACT (
     <text1>, <text2>
)

How do you use the EXACT function?

You can use EXACT function to test text being entered into a document.
The EXACT function is quite useful when we wish to deal with case-sensitive data.

Related Blog Posts

Related Support Forum Posts

How to calculate multiple rows for a condition
Anonymizing Data For Assistance Request
Calculating Orders with single product per period (day)

Considerations when using the EXACT function

Arguments:

  1. Text1 (required argument) – This is the first string which we wish to join. It can be two text strings, numbers, or logical value.
  2. Text2 (required argument) – This is the second text string.

The EXACT function returns TRUE if the two strings are the same. The EXACT function returns FALSE if the two strings are different.

Related Video Tutorials

Formula examples using the EXACT function

=EXACT(“apple”,”apple”)

=EXACT(A3,B3)

=EXACT(“Apple”,”apple”) // returns FALSE

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide