Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
How to count cells that are 1) blank or 2) empty or 3) only include one or more empty chars like SPACE and TAB?
Thanks!
Solved! Go to Solution.
@UsePowerBI , remove the empty space using trim or text.trim in M
Countrows(filter(Table,isblank(table[column])))
calculate(Countrows(table),filter(Table,isblank(table[column])))
@UsePowerBI , remove the empty space using trim or text.trim in M
Countrows(filter(Table,isblank(table[column])))
calculate(Countrows(table),filter(Table,isblank(table[column])))
User | Count |
---|---|
98 | |
90 | |
83 | |
69 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |