EXACT
Whether two texts are the same, case counting.
Group: Text. Compatible with DAX.
Syntax
EXACT ( <text1>, <text2> )| Parameter | Type | Description |
|---|---|---|
text1 | Text | One text to compare. |
text2 | Text | The other text. |
Returns
Boolean. TRUE when the two texts are the same character for character, FALSE otherwise.
Remarks
- Upper and lower case count here, while the
=operator ignores them:"Pils" = "pils"is TRUE,EXACT ( "Pils", "pils" )FALSE. - Spaces count too, at the end of a text as much as anywhere.
- A blank is the same as empty text, and a number is compared as its text:
EXACT ( 1, "1" )is TRUE.
Examples
EXACT and the = operator
EVALUATE
ROW (
"EXACT", EXACT ( "Pils", "pils" ),
"=", "Pils" = "pils",
"Same case", EXACT ( "Pils", "Pils" ),
"A space more", EXACT ( "Pils ", "Pils" )
)| EXACT | = | Same case | A space more |
|---|---|---|---|
| FALSE | TRUE | TRUE | FALSE |
Blanks and numbers
EVALUATE
ROW (
"Blank and empty", EXACT ( BLANK (), "" ),
"Number and text", EXACT ( 1, "1" )
)| Blank and empty | Number and text |
|---|---|
| TRUE | TRUE |