Count non blank values inside a row

[Haroldosilva]

Hi, I'm looking for a fuction or another way to criate a new columm (or a new table) with the counting of non blank values in each line.  Like the columm "Conuting nonblank" below.

For example: 6 in line #1; 7 in line #4.

Regards

[amitchandak]

@Haroldosilva , check if these can help

https://docs.microsoft.com/en-us/dax/countblank-function-dax

https://www.youtube.com/watch?v=EoRjNx1G2g4

[mahoneypat]

This is more easily done in the query editor with Record and List functions.  Here is an example.  To see how it works, just create a blank query, go to Advanced Editor, and replace the text there with the M code below.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXICYmelWJ1oJRcgyxWIlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1, Int64.Type),
    #"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each List.Count(List.Select(Record.ToList(#"Added Index"{[Index]}), each _<> ""))-1)
in
    #"Added Custom"

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat