Forum Discussion
Custom Column based in Aggregated Data after Grouping
Hello! Is there a way to create an IF/THEN function that reads from the aggregated data nested in each row after grouping by certain column? I grouped by TRACKER and inserted an index that cou...
=Table.Combine(Table.TransformColumns(#"Grouped Rows",{"COUNT TRACKER",each Table.CombineColumns(Table.AddIndexColumn(_,"idx",1),{"TRACKER INDEX KEY","idx"},each _{0}&Text.From(_{1}),"TRACKER INDEX KEY")})[COUNT TRACKER])