Forum Discussion

PhilippeMuniesa's avatar
PhilippeMuniesa
Resolver I
3 years ago
Solved

Table.AggregateTableColumn with list of list and conditional function

Hello, I have a table with several columns, I created a list of column headers. then I grouped in a DATA column the columns of the table without aggregation. I would then like to expand the tables i...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    3 years ago

    I think your aggregation list is incorrect syntax.

     

    Try:

     

     

    List.Transform(My_Liste, each if Text.Contains(_,"50.002") then {_, List.Sum, "sum of " & _, type number} else {_, List.Max, "Max of " & _, type number})

     

  • PhilippeMuniesa's avatar
    PhilippeMuniesa
    3 years ago

    Thank you very much,

    I still have a bit of trouble with lists and list.transform

     

    Philippe

ronrsnfld's avatar
ronrsnfld
Super User
3 years ago

I think your aggregation list is incorrect syntax.

 

Try:

 

 

List.Transform(My_Liste, each if Text.Contains(_,"50.002") then {_, List.Sum, "sum of " & _, type number} else {_, List.Max, "Max of " & _, type number})