Forum Discussion

awais692's avatar
awais692
New Member
5 years ago
Solved

Count if formula for multiple columns in power query

How to write a formula =countif(A2:M2,"<=15") in power query?
Need Help
Show and Tell
  • Jakinta's avatar
    Jakinta
    5 years ago

     

    = List.Count(List.Select(PriorStepName[ColumnName], each _<=15))

     

Jakinta's avatar
Jakinta
Icon for Solution Sage rankSolution Sage
5 years ago

 

= List.Count(List.Select(PriorStepName[ColumnName], each _<=15))