Counting number of values in a column

[Greg888]

Hi all 

Is there a way of counting the number of values in a column in Power BI (see screen shot below)

I also have this column, comma separated.

For instance 10 70 = 2

[Greg888]

Thanks @hannibalmads I really need to get more into Custom columns, it's so powerful yet I've never really explored it properly. Any good resources you could recommend? Thanks again

[hannibalmads]

Great to hear. Power Query and the M language is totally underappreciated (in my opinion) in terms of documentation as well as usage, but this book is my bible

https://excelguru.ca/master-your-data/  

[hannibalmads · Accepted solution]

Create a Custom Column and add this formula:

List.Count(Text.PositionOf([Home Team Goal Minute],",",Occurrence.All )) + 1

Your screenshot shows that it is separated by a space and not a comma, if that's the case then this should work:

List.Count(Text.PositionOf([Home Team Goal Minute]," ",Occurrence.All )) + 1