admin管理员组

文章数量:1315344

I have a column that shows the tickets assigned to each user. For example, User1 has "ticket2, ticket4, ticket5". User2 has "ticket1, ticket3". I want to count the number of tickets each user has. I can't use the number of words separated by commas as a criterion, for example, because User3 can have something like "ticket6, ticket7, HHGG", where HHGG stands for something else. How can I do that?

I tried converting each of the rows with the tickets into a list, to count the number of items, but I don't know how to filter the ones that I need. I used: Count = Table.AddColumn(#"Added Conditional Column2", "INC Count", each Text.Split([#"SNow#"], ","))

I have a column that shows the tickets assigned to each user. For example, User1 has "ticket2, ticket4, ticket5". User2 has "ticket1, ticket3". I want to count the number of tickets each user has. I can't use the number of words separated by commas as a criterion, for example, because User3 can have something like "ticket6, ticket7, HHGG", where HHGG stands for something else. How can I do that?

I tried converting each of the rows with the tickets into a list, to count the number of items, but I don't know how to filter the ones that I need. I used: Count = Table.AddColumn(#"Added Conditional Column2", "INC Count", each Text.Split([#"SNow#"], ","))

  • text
  • powerbi
Share Improve this question asked Jan 30 at 9:31 Florencia LunaFlorencia Luna 132 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 0

If your data size is relatively small you could try adding a custom column with the code:

List.Count(Text.PositionOf([Test], "ticket", Occurrence.All))

本文标签： powerbiPower BI Count the number of times a text appears in each rowStack Overflow

版权声明：本文标题：powerbi - Power BI: Count the number of times a text appears in each row - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741976189a2408136.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。