Forum Discussion
List.Generate creates list with more rows than expected
(table1 as table, fault_status as number, Index as number, ID as text)=> let row_count = Table.RowCount(table1), current_row = Table.SelectRows(table1, each [ID] = ID), Index = current_row[Ind...
let
source=table1,
custom1=Table.FromRecords(List.Accumulate(Table.ToRecords(source),{{},[]},(x,y)=>let a=(Record.FieldOrDefault(x{1},y[ID],0)+y[falult_status])*y[fault_status] in {x{0}&{y&[NewCol=a]},x{1}&Record.AddField([],y[ID],a)}){0})
in
custom1
