Forum Discussion

AtchayaP's avatar
AtchayaP
Helper V
4 years ago

Powerbi and excel

Anybody help me? amitchandak
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Use the following formula in a custom column in Power Query

 

= List.Count(Text.Split([skills],","))

 

For DAX

 

= LEN([skills])-LEN(SUBSTITUTE([skills],",",""))+([skills]<>"")

 

AtchayaP's avatar
AtchayaP
Helper V
4 years ago

I have used the 1st formula, but it's not counting the exact numbers in cell.i have 5skills in one cell, but it's counting as 7.could you help me