Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors