Count text with comma delimiter in a column

[Anonymous]

I want to count text which has comma delimiter. See below screenshot

my expected result should be 

This is counting Answer column and comma delimiter separate one text from the other.

How can i achieve this?

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Create a custom column from Power Query like below:-

List.Count(Text.Split([Answer], ","))

Output:-

Thanks,

Samarth

[Anonymous]

@Samarth_18 thanks for the solution.
However, I getting Error for those that has null value in Answer column.
How can i fix it?