Count calculated columns

[TonyHansson]

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         2

D9000         3

How can I do this ?

Regards Tony

[TonyHansson · Accepted solution]

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]

let
    Source = your_table,
    group = Table.Group(Source, {"Origin2"}, {{"Count", each {1..Table.RowCount(_)}}}),
    expand = Table.ExpandListColumn(group, "Count")
in
    expand

[TonyHansson]

= Table.AddColumn(#"Removed Columns4", "Custom",  let source = SAPIMPORT,
group = Table.Group(source, {"Origin2"}, {{"Count",each {1..Table.RowCount(_)}}}),
expand = Table.ExpandListColumn(group, "Count")
in expand)

Expression.Error: The column 'Origin2' of the table wasn't found.
Details:
Origin2

Origin2 is not a part of the table "SAPimport" but created later

Tony

[foodd]

Excel Power Query from same workbook:

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
group = Table.Group(Source, {"Origin2"}, {{"Count", each {1..Table.RowCount(_)}}}),
expand = Table.ExpandListColumn(group, "Count")
in
expand

[foodd]

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]

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]

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.  

[AlienSx]

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

[TonyHansson]

Hi @AlienSx 

sapimport is the table, the power query is using