DAX Text - EXACT function

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