Forum Discussion
Numbers of rows where is not null
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 |
7 Replies
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!
Thank Alan,
Where I precise my columns names ( [Column1] and [Column2] and [Column2] )
I misspoke,
I would like create new column 'Result' for have the same output like my exemple in the first topic.
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!
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
