Forum Discussion

Copper Contributor

Oct 15, 2021

COUNTIF multiple specific columns in POWER QUERY

Hi dears in no. of working machines cell (orange), I need to count how many machine working from (yellow cells) with condition that the number should be more than 95! how can i do t...

SergeiBaklan

Diamond Contributor

Oct 24, 2021

markfikry

It's hard to recognize something on such screenshot. For the model like this

COUNTIF() could be

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Inserted Count" = Table.AddColumn(
        Source,
        "Count",
        each List.NonNullCount(
                List.Transform( {[A], [B], [C], [D], [E]},
                    each
                        if List.Sum( {_, 0} ) > 95
                        then _
                        else null
                )
        ),
    Int64.Type)
in
    #"Inserted Count"

Please check in attached file.

markfikry

Copper Contributor

Nov 12, 2021

this is applicable for PowerBI? not working for me