The syntax for the EXACT function in Power BI DAX is as follows:
Here, `Text1` and `Text2` are the two text strings that you want to compare. The function returns a true or false value based on whether the two strings are identical.
How to Use the EXACT Function
To use the EXACT function in Power BI DAX, you need to follow these steps:
Step 1: Open Power BI
The first step is to open Power BI on your computer.
Step 2: Create a New Report
Next, create a new report by clicking on the "Create a New Report" button.
Step 3: Add Data to the Report
To use the EXACT function, you need to have some data in your report. You can either use an existing dataset or import data from an external source.
Step 4: Create a New Measure
Once you have added the data to your report, you need to create a new measure. To do this, click on "New Measure" under the "Modeling" tab.
Step 5: Enter the EXACT Function
In the formula bar that appears, enter the following formula:
MeasureName = EXACT(Text1, Text2)
Here, `MeasureName` is the name that you want to give to your new measure, `Text1` is the first text string that you want to compare, and `Text2` is the second text string that you want to compare.
Step 6: Save and Use the Measure
Once you have entered the formula, click on "Save" to save the measure. You can now use this measure in your report.
Examples of Using the EXACT Function
Here are some examples of using the EXACT function in Power BI DAX:
Example 1: Comparing Two Identical Text Strings
Suppose you have two text strings, "Hello, World" and "Hello, World". To check whether these two strings are identical, you can use the following formula:
MeasureName = EXACT(“Hello, World”, “Hello, World”)
This will return a true value, indicating that the two strings are identical.
Example 2: Comparing Two Different Text Strings
Suppose you have two text strings, "Hello, World" and "hello, world". To check whether these two strings are identical, you can use the following formula:
MeasureName = EXACT(“Hello, World”, “hello, world”)
This will return a false value, indicating that the two strings are not identical.
The EXACT function in Power BI DAX is a useful tool for comparing two text strings and checking whether they are identical. By following the steps outlined above, you can easily use this function in your Power BI reports.