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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This formulae does not seem to work in my case, which is very similar. I got all error values.