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 - 1
tton Bld-1KN/5_A1400101-FONth/2/1_A1428673-GIANSSI_A153748 - 3

 

thank you!

  • 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

1 Reply

  • 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