Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Count across columns

Hi,   I have a data like the below (first 4 columns)   In PowerQuery M, I want to add a new column called 'Agent Count' with a count of the number of agents enabled per machine.   I have lo...
Need Help
  • ImkeF's avatar
    ImkeF
    7 years ago

    Hi Anonymous 

    simply add a column with this formula:

    List.Count(List.Select(Record.FieldValues(_), (x) => Text.Contains(x, "enabled")))

     

     

ImkeF's avatar
ImkeF
Community Champion
7 years ago

Hi Anonymous 

simply add a column with this formula:

List.Count(List.Select(Record.FieldValues(_), (x) => Text.Contains(x, "enabled")))

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

That was much simpler than I thought. Thank you imkyu