Forum Discussion

Helper V

4 years ago

Powerbi and excel

Anybody help me? amitchandak

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]<>"")

Helper V

4 years ago

Actually in excel I can see values but after transforming to pwerbi, it is showing as null.why it is? Is that because of data cleaning is not good.?