Forum Discussion

3 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    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)