Forum Discussion
awais692
Jul 26, 2021Copper Contributor
Count if formula for multiple columns in power query
How to write a formula =countif(A2:M2,"<=15") in power query?
SergeiBaklan
Jul 26, 2021Diamond Contributor
If you mean to countif() each row of the table, as variant
- add Index column starting from 0
- add custom column with formula
=List.Accumulate(Record.ToList(#"Added Index"{[Index]}),0, (s,c) => s+Number.From(c<= 15))