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

     

     

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

 

 

 



TonyHansson's avatar
TonyHansson
Frequent Visitor
2 years ago

Hi foodd 

Thank you

 

I get the measage:

 

Expression.Error: We cannot convert a value of type Table to type Function.
Details:
Value=[Table]
Type=[Type]

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    Glad that you succeeded in determining a solution that would meet your end needs, and that AlienSx was able to provide a working solution to your original requirements.  However, this error message had nothing to do with the Solution  AlienSx provided that met the requirement as requested.