Reply
Member
Posts: 46
Registered: ‎06-16-2016
Accepted Solution

Count non-blank cells across a range of columns

Hello,

I am trying to create a column that basically counts the number of columns for each row that are not blank. See image. The value i'm looking for would be 4 for the top few rows since ther are 4 columns that are not null.

Is there a way to do this in query editor?Capture.JPG

 


Accepted Solutions
Super User
Posts: 634
Registered: ‎02-29-2016

Re: Count non-blank cells across a range of columns

@heidibb

Yes, if you click Custom Column on the ribbon, in the dialog box enter this in the formula section:

=List.NonNullCount(Record.FieldValues(_))

Regards,

Owen

View solution in original post


All Replies
Super User
Posts: 634
Registered: ‎02-29-2016

Re: Count non-blank cells across a range of columns

@heidibb

Yes, if you click Custom Column on the ribbon, in the dialog box enter this in the formula section:

=List.NonNullCount(Record.FieldValues(_))

Regards,

Owen