Forum Discussion

andrius_pfa's avatar
andrius_pfa
New Member
4 years ago
Solved

Count ID's from text

Hello, Im new to Power Bi , and I need help. I want to create column and count how many ID's begins with _A. Example:   ing-WoX8/1/1_A1385556-Xdu Trou6_A1407390-Maon - 2 S5/1/1_A1385448-VALENANI ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi andrius_pfa ,
    you can use this formula for creating this column.

    _A count = 
VAR Search_string = "_A"
RETURN
DIVIDE(
    LEN('Table'[Value]) - LEN(SUBSTITUTE('Table'[Value],Search_string,BLANK())),
    LEN(Search_string),
    0
)


    Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi andrius_pfa ,
you can use this formula for creating this column.

_A count = 
VAR Search_string = "_A"
RETURN
DIVIDE(
    LEN('Table'[Value]) - LEN(SUBSTITUTE('Table'[Value],Search_string,BLANK())),
    LEN(Search_string),
    0
)


Regards