在PowerQuery表中如何计数行，仅包含文本值

Question

好一天，如何在PowerQuery中的表格中计算一行仅包含文本值的行。

我想要这种格式的桌子。

邮件	Listern	Boby	Total
B	1	C	2
B	0	3	1

Answer 1

 let
        Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclJQ0lEyBBHOCkqxOlABAxBhDBSIBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Mail " = _t, #"listern " = _t, #"Boby " = _t]),
        #"Added Custom" = Table.AddColumn(Source, "Custom", each 
        let a = Record.ToList(_),
        b = List.Transform(a, each try Number.From(_) otherwise "Text" ),
        c = List.Select(b, each _ = "Text" ),
        d = List.Count(c)
        in d,  Int64.Type)
    in
        #"Added Custom"

Answer 2

PowerQuery的另一种方式

#"Added Custom" = Table.AddColumn("#PriorStepNameHere", "TOTAL", each  List.Sum(List.Transform(Record.ToList(_), each try Number.From(_)-Number.From(_) otherwise 1)))

Answer 3

如果您愿意，可以通过公式进行。

=SUM(--ISTEXT(A2:C2))