Looker Studio Function : UPPER
UPPER Function in Looker Studio – Standardize Text to Uppercase
Category: Text Function
The UPPER function in Looker Studio is a text function used to convert all alphabetic characters in a text value into uppercase. Although simple in nature, this function plays an important role in maintaining text consistency across dashboards, especially when data comes from multiple systems or manual inputs.
In real-world reporting, text values such as city names, state codes, product categories, or campaign identifiers may appear in different cases. This inconsistency can lead to incorrect grouping, filtering, or comparisons. The UPPER function helps eliminate such issues by converting all values into a uniform uppercase format.
From a BI perspective, UPPER is commonly used in calculated dimensions before applying filters, joins, or comparisons. It is especially useful when business standards require uppercase values, such as state codes or region identifiers. Since UPPER operates at row level and does not change the source data, it is safe and efficient for large datasets.
Overall, UPPER is a simple but essential function for improving data readability, consistency, and reporting accuracy in Looker Studio.
Purpose of UPPER Function
1. Text Standardization
Converts mixed-case text into a consistent uppercase format for reporting accuracy.
2. Reliable Comparisons
Prevents mismatches caused by case differences during filtering or conditional checks.
3. Business Formatting
Ensures text follows organizational standards such as uppercase codes or labels.
4. Clean Dashboard Output
Improves visual consistency and professionalism of dashboard text fields.
Type of Calculation & Practical Use Cases
1. Calculated Dimensions
Used to create standardized calculated dimensions for grouping and filtering.
2. Data Cleaning
Helps clean inconsistent casing in imported or user-entered text data.
3. Pre-Comparison Processing
Applied before comparisons to ensure accurate matching results.
4. Multi-Source Data Handling
Useful when combining datasets with inconsistent text casing.
UPPER(text)
UPPER Function Function – Parameters Table
| Parameter | Type | Description |
|---|---|---|
| text | Text | The text value to be converted into uppercase |
How Does the UPPER Function Work?
The UPPER function scans the input text and converts every lowercase alphabetic character into its uppercase equivalent. Numbers, spaces, and special characters remain unchanged.
For example, "Sales-India" becomes "SALES-INDIA". The function processes each row independently and returns uppercase text. If the input text is NULL, the function returns NULL without modification.
When Should You Use UPPER Function?
When standardizing text case
When preparing data for comparisons
When enforcing uppercase naming standards
When cleaning inconsistent text values
When combining data from multiple sources
Examples of UPPER Function
Example 1: Convert City Names to Uppercase
UPPER(City)
Example 2: Standardize State Codes
UPPER(State_Code)
Example 3: Use with TRIM Function
UPPER(TRIM(Product_Category))
Tips & Best Practices
Apply UPPER before comparisons or joins
Combine with TRIM for clean text
Use consistently across similar fields
Test output using table views
Avoid unnecessary nested transformations
No, UPPER only converts alphabetic characters and does not modify numbers, spaces, or special characters.
UPPER is not case-sensitive; it simply converts all alphabetic characters into uppercase format.
UPPER is mainly used in calculated dimensions rather than metrics, as it returns text values.
If the text value is NULL, the UPPER function returns NULL without any changes.
For simple case conversion, UPPER is simpler, faster, and more readable than regex-based solutions.