PQ: Text.Combine + Sum of Values with Dates

[Pulsar3000]

Hi All:

I have a group of rows whose text in the Description column is being combined based on each unique value of the Index column.
However, I also have a Date column. Each unique value in the Index Column has one date only that I want reflected in the output.
Additionally, three other columns (Credit, Debit, and Balance) should be totaled based on each unique value of the index column.

Right now I have the below code but get the error "We cannot convert a value of Type List to Type Text."

Table.Group(#"Changed Typed", {"Index"}, {{"Description", each Text.Combine([Description], " | "),type text}, {{Date}, {{"Credit", each List.Sum([Credit]), type nullable number}, {"Debit", each List.Sum([Debit]), type nullable number}, {"Balance", each List.Sum([Balance]), type nullable number}}}})

 

[Pulsar3000]

Hi All:

I have a group of rows whose text in the Description column is being combined based on each unique value of the Index column.
However, I also have a Date column. Each unique value in the Index Column has one date only that I want reflected in the output.
Additionally, three other columns (Credit, Debit, and Balance) should be totaled based on each unique value of the index column.

Right now I have the below code but get the error "We cannot convert a value of Type List to Type Text."

Table.Group(#"Changed Typed", {"Index"}, {{"Description", each Text.Combine([Description], " | "),type text}, {{Date}, {{"Credit", each List.Sum([Credit]), type nullable number}, {"Debit", each List.Sum([Debit]), type nullable number}, {"Balance", each List.Sum([Balance]), type nullable number}}}})

I figured it out. Basically just tweaked the Date item.


Table.Group(#"Changed Typed", {"Index"}, {{"Description", each Text.Combine([Description], " | "),type text}, {"Date", each List.Max([Date]), type date}, {"Credit", each List.Sum([Credit]), type nullable number}, {"Debit", each List.Sum([Debit]), type nullable number}, {"Balance", each List.Sum([Balance]), type nullable number}})