EXACT

Updated on

EXACT is a DAX function that checks if two text strings are exactly the same, considering case sensitivity.

Syntax

EXACT(
   Text1,
   Text2
)
Argument Properties Description
Text1 The first text string.
Text2 The second text string.

Return Values

True or False. (Boolean)

Example

The following formula used in a calculated column in the Product table checks the value of Product for the current row against the value of Model for the current row, and returns True if they are the same, and returns False if they are different.

Examples in this article can be used with the sample Adventure Works DW 2020 Power BI Desktop model. To get the model, see DAX sample model.

= EXACT([Product], [Model])

Other functions related to EXACT are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/exact-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy