Forum Discussion

Frequent Visitor

2 years ago

Solved

Count calculated columns

I have table. Origin2 D8000 D8000 D9000 D9000 D9000 I want add a column making a calculated count. Origin2 Count D8000 1 D8000 2 D9000 1 D9000 ...

Need Help

TonyHansson
2 years ago
Hi

Found this youtube:

= Table.AddColumn(BufferedTable, "RunningCount", (OT) => Table.RowCount( Table.SelectRows(BufferedTable, (IT) => IT[Transaction No] <= OT[Transaction No] and IT[Origin2] = OT[Origin2])))

Thank you for help

foodd

Community Champion

2 years ago

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcrEwMDBQitVBYVniZMUCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Origin2 = _t]),
group = Table.Group(Source, {"Origin2"}, {{"Count", each {1..Table.RowCount(_)}}}),
expand = Table.ExpandListColumn(group, "Count")
in
expand