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

You have a single column table in your original message. What is SAPimport? We are not aware of this. 

TonyHansson's avatar
TonyHansson
Frequent Visitor
2 years ago

Hi AlienSx 

 

sapimport is the table, the power query is using