EXACT

How to Use the Power BI DAX function EXACT

Syntax

The syntax for the EXACT function in Power BI DAX is as follows:

EXACT(Text1, Text2)

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.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)