Downloads
Power Query MTextBeginner

Text.Lower

Converts all letters in a text value to lower case.

Syntax
Text.Lower(text as nullable text, optional culture as nullable text) as nullable text

Returns: The text in lower case, or null when the input is null.

What it does

Text.Lower puts every letter in lower case. It is most useful for values that people type by hand, such as email addresses and web domains, where "Billing@Acme.com" and "billing@acme.com" are the same address but compare as different text. Lowering both sides before a comparison removes that noise.

Syntax and arguments

Example

An accounts receivable team has two lists of customer emails, one from the CRM and one from the billing system. The emails are lowered on both sides before the merge, so a customer typed twice with different capitals is found once.

let
    Crm = #table(type table [Email = text], {{"Billing@Acme.com"}, {"ap@Blue-Harbor.com"}}),
    Billing = #table(type table [BillingEmail = text], {{"billing@acme.com"}}),
    CrmKey = Table.TransformColumns(Crm, {{"Email", Text.Lower, type text}}),
    BillingKey = Table.TransformColumns(Billing, {{"BillingEmail", Text.Lower, type text}}),
    Matched = Table.Join(CrmKey, "Email", BillingKey, "BillingEmail", JoinKind.Inner)
in
    Matched

The Acme address matches after both sides are lowered, so the result has one row. The Blue Harbor address has no match and drops out of an inner join.

Example: a second, different use

Lower the case of a file name before checking it against an expected name such as "bank_statement_2026_09.csv".

Things to watch

In business terms

Email addresses, vendor domains and file names arrive with mixed capitals from many sources. A lower case key column is the usual way to merge them without losing records to capitalization.

Related functions

All Power Query M functions · View as Markdown · M basics