cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Count Letters in Records?

Hallo Guys,

I have this table and at the end of each table I have a list.

Screenshot 2021-01-19 083448.png

How can I count the number of U letters in this list.

Screenshot 2021-01-19 083659.png

Thanks in advance.

 

with best regards
kelu

1 ACCEPTED SOLUTION
AlB
Super User
Super User

@Anonymous 

Where exactly is the list? Is if a field of a record? Make sure you build te list correctly. It looks like you are not specifying the field for the record.

Can you share the pbix? Try something like:

List.Count(List.Select(Record.ToList(Record.SelectFields(RecordName, {Fieldname})) , each _ = "U")) 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

SU18_powerbi_badge

View solution in original post

3 REPLIES 3
AlB
Super User
Super User

@Anonymous 

Where exactly is the list? Is if a field of a record? Make sure you build te list correctly. It looks like you are not specifying the field for the record.

Can you share the pbix? Try something like:

List.Count(List.Select(Record.ToList(Record.SelectFields(RecordName, {Fieldname})) , each _ = "U")) 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

SU18_powerbi_badge

View solution in original post

AlB
Super User
Super User

Hi @Anonymous 

Try this

List.Count(List.Select(YourListName_, each _ = "U")) 

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

SU18_powerbi_badge

Anonymous
Not applicable

@AlB Thanks for the answer!

I tryed: 

Screenshot 2021-01-19 104738.png

I tried implementing that but I could not get I to work.

Screenshot 2021-01-19 104811.png

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors