It’s a Text function that used to compares two text strings and returns TRUE if they are exactly the same, otherwise returns FALSE. EXACT is case-sensitive but ignores formatting differences.
text1– The first text string or column that contains text.
text2– The second text string or column that contains text.
Sample dataset as below-
Let’s start with an example-
As you can see in above sample dataset we have two columns col1 & col2, now we will compare both columns values.
Now, add one calculated column and write below DAX function-
Exact Result = EXACT('Sample'[col1], 'Sample'[col2])
Here, EXACT DAX function will compare both columns values and if they are exactly the same it will returns TRUE, otherwise returns FALSE and it is case-sensitive DAX function.
Refer more DAX functions: DAX functions
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.