"A cyclic reference was encountered during evaluation" error when creating new column

[jasonyeung87]

Hi,

I'm trying to create a new column in my dataset that contains a concatenated string of row values of matching records. I'm using the Power Query editor and below is a sample of my recordset:

The new column's name is "Patch Status All" and I'm matching based on the computer name. What I want is to have this column contain a contatenated string of the "Patch Status" value of records that have the same computer name. For example, there are 2 rows with the computer name "1L3CD2Q". Each row has a different "Patch Status": Patches Not Attempted and Agent Offline. I want the value of "Patch Status All" to be "Patches Not Attempted; Agent Offline" for both rows.

I'm trying to use the "Table.SelectRows" function to obtain the rows, but I am receiving the error "Expression.Error: A cyclic reference was encountered during evaluation.". The power query I'm using is:

= Table.SelectRows(
#"Non-compliant Assets",
each ([ComputerName] = "")
)

(the initial test was to compare ComputerName to a blank string, but even that generates the same error. I was wondering if there's a function that allows me to get a concatenated string of matching rows?

Jason

[amitchandak]

@jasonyeung87 , Use last step table name

= Table.SelectRows(
#"Renamed Columns,
each ([ComputerName] = "")
)