Curious about Table.Group aggregatedColumns function

Hi hansei,

I think this should be related to the let-in structure and _ operator.
In the 'group' function, the _ operator after 'each' keyword mapping to the table type, and can be recognized and evaluated after each keyword but these operations seem not processed in the nested let-in structure. (perhaps related to Lazy and eager evaluation)

Evaluation model - PowerQuery M | Microsoft Docs

For your scenario, you can try to use the following formula to fix this issue:

Table.Group(#"Kept First Rows", {"Claim ID"}, {{"MinPrice", each let n = List.Min(_[Contract Price]) in n,  type nullable number}})

Regards,

Xiaoxin Sheng