LOWER

How to Use the Power BI DAX function LOWER

What is the LOWER function in Power BI?

The LOWER function in Power BI is a DAX function that converts all uppercase letters in a text string to lowercase. The syntax for the LOWER function is as follows:


LOWER(❰text❱)


Where `❰text❱` is the text string that you want to convert to lowercase.

How to use the LOWER function in Power BI?

Using the LOWER function in Power BI is quite simple. You just need to follow these steps:

1. Create a new measure or calculated column in Power BI.

2. Use the LOWER function in the formula bar.

3. Specify the column that contains the text you want to convert to lowercase.

Let's take a look at an example to see how this works.

Suppose you have a table named `Sales` that contains a column named `Product Name`. This column contains the names of various products in uppercase letters. You want to convert these names to lowercase letters. Here's how you can do this:

1. Go to the `Modeling` tab in Power BI and select `New Measure`.

2. In the formula bar, type the following formula:


Product Name Lower = LOWER(Sales[Product Name])


3. Press `Enter` to create the new measure.

Now, you can use the `Product Name Lower` measure in your visualizations to display the product names in lowercase letters.

In this article, we explored how to use the Power BI DAX function LOWER to convert text to lowercase. We saw that using the LOWER function is quite simple and only requires a few steps. By using the LOWER function, you can easily manipulate text data in your Power BI reports and visualizations.

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

Upcoming Courses

6-8 Jun 23 (London or Online)
8-10 Aug 23 (London or Online)
24-26 Oct 23 (London or Online)

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)