Text.Upper
TextConverts all characters in a text value to uppercase.
Syntax
Text.Upper(text as nullable text, optional culture as nullable text) as nullable textParameters
| Name | Type | Required | Description |
|---|---|---|---|
text | text | Yes | The text value to convert to uppercase. |
culture | text | No | A culture code (e.g., "en-US") that determines locale-specific casing rules. |
Return Value
text — The input text with all characters converted to uppercase.
Remarks
Text.Upper converts every character in a text value to its uppercase equivalent. This is useful for standardizing text data before comparisons or grouping — for example, ensuring that "east", "East", and "EAST" all become "EAST".
For locale-sensitive casing (e.g., Turkish İ/i), pass the appropriate culture code as the second argument.
Examples
Example 1: Uppercase employee names
Table.TransformColumns(
Table.SelectColumns(Table.FirstN(Employees, 3), {"FullName"}),
{"FullName", Text.Upper, type text}
)Result
FullName | |
|---|---|
| 1 | ALICE SMITH |
| 2 | BOB JONES |
| 3 | CHARLIE BROWN |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks