Forum Discussion
Solved
Counting Number of Elements in Array
Having two columns: NUMBER ID ABC015753 0001612224-25-1,0001612224-25-2,0001612224-25-3,0001612224-25-4 ABC015761 EBC257D 85C16327 599F8358 CC990AEF 64CD90C5 ABC015787 56567ZXC; 6...
Hi, joe100
You can create a custom column in pq.
Like this:
List.Count(Text.PositionOfAny([ID], {","," ",";"}, -1))If you need to add newlines, you can use ‘#lf’:
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
v-janeyg-msft
Community Support
Community SupportHi, joe100
You can create a custom column in pq.
Like this:
List.Count(Text.PositionOfAny([ID], {","," ",";"}, -1))If you need to add newlines, you can use ‘#lf’:
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Sure, thank you!