Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi dear Community,
In Power BI (Desktop)
I have 20 columns with numbers and and I need to count them if they match with a value (i.e. count if the column's value = 0)
I need to create a new column with this count
Any advice how I can calculate it, since the countif function (for columns) does not exist in Power Bi
I appreciate your help
Carlos G.
With Query Editor, We can add a custom Column like
List.Count(List.Select(Record.ToList(_),each _ =0))
Thanks a lot for your help..
It worked, but I would like to understand it better.
Could you try to explain it in a few words?...pleaseee... I appreciate it
Thanks a lot
Carlos G.
Hi Zubair,
Actually, I would like to know how I can specify a contigous range of columns in order to apply this "count if"...
How I can do it?
Below the 3 columns that I need to apply this "Count If"
You could use IF Functions in Power Query Including Nested IF for these three columns
https://www.computergaga.com/blog/if-functions-in-power-query-including-nested-ifs/
For example:
if [Column1]" and [Column2] and [Column3] then <Your expected outrput> else <Your other output>
Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |