Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count Letters in Records?

Hallo Guys, I have this table and at the end of each table I have a list. How can I count the number of U letters in this list. Thanks in advance.   with best regards kelu
Need Help
  • AlB's avatar
    AlB
    5 years ago

    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 

     

AlB's avatar
AlB
Community Champion
5 years ago

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