Table.Group with GroupKind.Local and Comparer => Expression.Error

Question

Hi

Searched previous Technet forum but didn't find something and not sure I understand:

let  
    Source = Table.FromRecords(  
        {[ID="A",Value=1],[ID="a",Value=1],[ID="b",Value=2],[ID="B",Value=2]},  
        type table [ID=text,Value=number]  
    ),  
    Group1 = Table.Group(Source, {"ID"},  
        {"Sum", each List.Sum([Value]), type number},null,Comparer.OrdinalIgnoreCase  
    ), // OK  
    Group2 = Table.Group(Source, {"ID"},  
        {"Sum", each List.Sum([Value]), type number},GroupKind.Global,Comparer.OrdinalIgnoreCase  
    ), // OK  
    Group3 = Table.Group(Source, {"ID"},  
        {"Sum", each List.Sum([Value]), type number},GroupKind.Local,Comparer.OrdinalIgnoreCase  
    ) // Expression.Error: We cannot apply operator < to types Record and Record  
in  
    Group3  

EDIT: Same error with GroupKind.Local, Comparer.FromCulture("en-US",true)
and GroupKind.Local, Comparer.Ordinal (not what I expect to achieve)

EDIT2: Changing the key (2nd argument) type from list to text does it

(Excel 365 64Bit v2010 Build 13328.20408 Click to run)
Thanks

Answer 1

Hi Lz. This appears to be a bug. We'll investigate a fix.

Answer 2

Appears to be fixed in XL 365 version 2102 build 13801.20266 - PQ v2.90.582.0

let  
    Source = Table.FromRecords(  
         {[ID="A",Value=1],[ID="a",Value=1],[ID="b",Value=2],[ID="B",Value=2]},  
         type table [ID=text,Value=number]  
    ),  
    Grouped = Table.Group(Source, {"ID"},  
        {"Sum", each List.Sum([Value]), type number},  
        GroupKind.Local, Comparer.OrdinalIgnoreCase  
    )  
 in  
    Grouped  

==>

Thanks @Ehren (MSFT) & Excel team