Text.Lower
TextConverts all characters in a text value to lowercase.
Syntax
Text.Lower(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 lowercase. |
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 lowercase.
Remarks
Text.Lower converts every character in a text value to its lowercase equivalent. This is commonly used to normalize text before case-insensitive comparisons or deduplication.
Examples
Example 1: Lowercase employee names
Table.TransformColumns(
Table.SelectColumns(Table.FirstN(Employees, 3), {"FullName"}),
{"FullName", Text.Lower, 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