EXACT DAX Function in Power BI
The EXACT function in Power BI (DAX) is used to compare two text strings and check if they are exactly the same. It is case-sensitive, meaning "Apple" and "apple" would not be considered equal.
DAX Syntax EXACT(text1, text2)
The function has the following parameters:
• text1: The first text string or column that contains text.
• text2: The second text string or column that contains text.
Example: Let’s create a measure with name “Comparison DAX Measure”.
DAX
Comparison DAX Measure = "Ashish" = "ashish"
The output of the above dax code is shown below:
DAX
Exact DAX Measure = EXACT("Ashish", "ashish")
The output of the above dax code is shown below:
