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 ...
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!