Count of Records Within One Column

Hi Anonymous 

You can duplicate this table, then group the column of colour by count of name, and then merge with the other table by colour column

Hi Jacob,

Select your [Fave Colour] column and go to Home tab > Group By.

In the dialog, keep the default count aggregated column, and also add another one using the 'All Rows' aggregator.

Expand the nested table column back out again.

Example Code:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8s1MzlbSUQpKTVGK1YlW8krMTkXiBpekloH4kak5OfnlYCGfzCpUAd/EomxUkYCMzBxUkeDEosQMNG35QL5TTmmqUmwsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, #"Fave Colour" = _t]),
    groupRows = Table.Group(Source, {"Fave Colour"}, {{"Count", each Table.RowCount(_), Int64.Type}, {"allRows", each _, type table [Name=nullable text, Fave Colour=nullable text]}}),
    expansAllRows = Table.ExpandTableColumn(groupRows, "allRows", {"Name"}, {"Name"})
in
    expansAllRows

Example Output:

Pete