- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count e-mail addresses
I have a table that contains different SharePoint sites.
I have a column called Group.Owners where I have the e-mail address to the owner/owners of that site.
There can be none, one or multiple e-mail addresses in that column. And there are of course different values on each row.
The e-mail addresses all have @ and if there are more than one, they are separeted by a semicolon.
Like this: person.1@domainone.com; person.2@domaintwo.com; person.33@dom.com
I want to, in the easiest way, count the number of e-mailaddresses on each row.
I thought the easiest way was to count how many times @ appears in that column on each row. But I cant figure out how to do this.
I need help!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Because some cell is null in Group.Owners column, you can use following code:
List.Count(Text.PositionOf([Group.Owners] ?? "", "@", Occurrence.All))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add a custom column,use following code:
List.Count(Text.PositionOf([Group.Owners], "@", Occurrence.All))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oh, great solution, but I get this error:
Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=[Type]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Because some cell is null in Group.Owners column, you can use following code:
List.Count(Text.PositionOf([Group.Owners] ?? "", "@", Occurrence.All))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I can see the ?? "" replaces the null values with empty text. Is there any documentation available about what the ?? exactly does and if there are other options as well? I cannot find anything and was not aware of this functionality
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Works well no. Just needed to click "Don't summerize" when I added the values from that column in my table.
Thank you for the code and the help.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
11-11-2024 11:32 PM | |||
11-14-2024 07:20 AM | |||
02-12-2024 02:45 AM | |||
02-23-2022 06:57 AM | |||
09-11-2024 06:04 AM |
User | Count |
---|---|
27 | |
27 | |
25 | |
13 | |
10 |
User | Count |
---|---|
24 | |
19 | |
16 | |
13 | |
10 |