Solved: Re: Count if formula for multiple columns in power...

How to write a formula =countif(A2:M2,"<=15") in power query?

1 ACCEPTED SOLUTION

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

1 REPLY 1

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

Helpful resources

Announcements

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

Check out the October 2025 Power BI update to learn about new features.

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.