I am calculating NPS with Power BI and created a new column for this. I have Grades column that holds grades given by customer and I ma creating new column which looks at the grade in Grade column and changes the grade to either Detractors, Passives or Promoters.
My problem is that some cells in Grades column may be empty. Now my syntax counts these empty cells as Detractors but it should count it as "Empty". How can I get the syntax to count empty cells as empty cells??