DAX Text - EXACT function
Advertisements
Description
Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise.
EXACT is case sensitive, but ignores formatting differences.
Syntax
EXACT (<text1>, <text2>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
text1 The first text string or column that contains text. |
2 |
text2 The second text string or column that contains text. |
Return Value
TRUE or FALSE.
Remarks
You can use EXACT function to test the text being entered into a document.
Example
= EXACT(Results[Sport], [Sport])
returns TRUE, if the value in Sport column in Results table match with the value in Sport column.
dax_functions_text.htm
Advertisements