Forum Discussion
Powerbi and excel
11 Replies
Hi AtchayaP - Split the Column by Delimiter. You can split the skills into new rows instead of columns.
Split a column of text (Power Query) (microsoft.com)Use the following formula in a custom column in Power Query
= List.Count(Text.Split([skills],","))For DAX
= LEN([skills])-LEN(SUBSTITUTE([skills],",",""))+([skills]<>"")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.?
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
Please post your data for me to verify...As long as there are 4 commas to separate the 5 words, it would count 5.
