Notifications
Clear all
Topic starter
I completed a Power Query and change the type of columns to Texts. After I loaded it into a table, I want to count only the texts of the columns, excluding the blanks. However, it counts the total rows instead.
I tried to use "replace values", but to no avail.
Can someone help?
Posted : 28/06/2023 8:46 am
When doing the replace values step(s) you should leave the 'value to find' box blank and put null in the replace with box.
Posted : 28/06/2023 11:56 am
