If you want comma counting approach, then use below formula
= Text.Length([skills])-Text.Length(Text.Replace([skills],",",""))+1
If you have blanks/nulls also, then use below formula
= Text.Length([skills])-Text.Length(Text.Replace([skills],",",""))+Number.From([skills]<>"" and [skills]<>null)
