Forum Discussion

TonyHansson's avatar
TonyHansson
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's avatar
    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

     

     

AlienSx's avatar
AlienSx
Super User
2 years ago
let
    Source = your_table,
    group = Table.Group(Source, {"Origin2"}, {{"Count", each {1..Table.RowCount(_)}}}),
    expand = Table.ExpandListColumn(group, "Count")
in
    expand