Numbers of rows where is not null

[Mat40220]

Hello developers,

I would like count the numbers of rows where is not null ?

Do you have an idea ?

Thanks !

Column 1	Column 2	Column 3	RESULT
2	null	null	1
null	6	7	2
null	null	null	0
4	7	10	3

[Anonymous]

Hello, you can use this

= Table.AddColumn(Source, "Custom", each List.Count( List.Select( Record.FieldValues(_), each _ <>null ) ) )

[Mat40220]

Thank Alan,

Where I precise my columns names ( [Column1]  and  [Column2] and  [Column2] )

[Mat40220]

I misspoke,

I would like create new column 'Result' for have the same output like my exemple in the first topic.

[serpiva64]

Hi,

in the attached file you can find 2 solutions (i don't really know what you need)

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

[Mat40220]

Thanks a lot serpiva,

but in my table i have other columns, i would like function work with precise my columns.

Examples

Other column ...	Other column ...	Column 1	Column 2	Column 3	RESULT
...	...	2	null	null	1
...	...	null	6	7	2
...	....	null	null	null	0
...	...	4	7	10	3

[serpiva64]

Hi, you obtain your result by applying the steps of the attached file

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

[serpiva64]

Hi,

you can use Remove blank rows

then you obtain this formula

= Table.SelectRows(Source, each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))

You need to change "" with "null"

= Table.SelectRows(Source, each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"null", null})))

finally you add an index column from 1

and you obtain your result

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!