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 ...
Hello, you can use this
= Table.AddColumn(Source, "Custom", each List.Count( List.Select( Record.FieldValues(_), each _ <>null ) ) )
Thank Alan,
Where I precise my columns names ( [Column1] and [Column2] and [Column2] )
