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?

  •  

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

     

1 Reply

  • Jakinta's avatar
    Jakinta
    Solution Sage

     

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