Create Custom column based on count of values in other columns

[Anders_G]

Hi,

I want to create a custom column (column 7) that does a count of non-null values in columns 1 to 6.

Need it as a Power Query.

Thank you!

[johnt75]

I think you could create a new column like

Column 7 =
VAR TmpTable = { 'Table'[Column 1], 'Table'[Column 2], 'Table'[Column 3] }
RETURN
    COUNTAX ( TmpTable, [Value] )

[Anders_G]

Thank you, that solution works for adding a column in the regular table view. But I just realised I need it as a Power Query. 

[johnt75 · Accepted solution]

I think you can use a similar principle. Add a custom column as

List.NonNullCount( { [Column 1], [Column 2], [Column 3] } )

[Anders_G]

Brilliant. Thank you very much!