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.
Syntax
EXACT(<text1>,<text2>)
Parameters
text1– The first text string or column that contains text.
text2– The second text string or column that contains text.
Sample dataset as below-
| ID | col1 | col2 |
| 1 | 123 | 123 |
| 2 | 125 | 178 |
| 3 | Bike | Bus |
| 4 | Cycle | Cycle |
| 5 | Hello | Hello |
| 6 | 878 | 567 |
| 8 | INDIA | india |
Let’s start with an example-
As observed in the above sample dataset, we have two columns, “col1” and “col2.” Our next step involves comparing the values within these two columns.
Now, add a 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.
