Forum Discussion

AtchayaP's avatar
AtchayaP
Icon for Helper V rankHelper V
4 years ago
Solved

Power query

Can anyone help me to show what syntax to be used I. Power query editor to get the count of skills
Need Help
Show and Tell
Tips and Tricks
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use following formula in a custom column

    = List.Count(Text.Split([skills],","))
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi AtchayaP ,

     

    Do your cells contain duplicate or empty skills? If so, please try this formula to see if it returns the correct result.

     

    = List.Count(List.RemoveItems( List.Distinct( Text.Split([skills],",")), {null,""," "} ))

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AtchayaP's avatar
AtchayaP
Icon for Helper V rankHelper V
4 years ago

Tried, but not getting exact count of skills

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi AtchayaP ,

 

Do your cells contain duplicate or empty skills? If so, please try this formula to see if it returns the correct result.

 

= List.Count(List.RemoveItems( List.Distinct( Text.Split([skills],",")), {null,""," "} ))

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.