Comparer.OrdinalIgnoreCase

Comparer

A case-insensitive ordinal comparer function.

Syntax

Comparer.OrdinalIgnoreCase as function

Return Value

function — A comparer function that performs case-insensitive ordinal comparisons.

Remarks

Comparer.OrdinalIgnoreCase is a built-in comparer function that performs case-insensitive ordinal comparisons. It treats uppercase and lowercase versions of the same letter as equal (e.g., "A" equals "a").

This comparer is commonly used with List.Distinct to deduplicate text that differs only by casing, and with List.Sort or Table.Sort to produce case-insensitive sorted results.

Examples

Example 1: Case-insensitive distinct on employee names

let
    Names = Table.Column(Employees, "FullName"),
    NamesWithDup = List.Combine({Names, {"ALICE SMITH"}}),
    Unique = List.Distinct(NamesWithDup, Comparer.OrdinalIgnoreCase)
in
    #table({"FullName"}, List.Transform(Unique, each {_}))

Result

	FullName
1	alice smith
2	BOB JONES
3	Charlie Brown
4	diana PRINCE
5	Eve Martinez
6	frank lee

Compatibility

✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks