Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |