topic Re: Count ID's from text in DAX Commands and Tips

Count ID's from text

andrius_pfa — Mon, 11 Apr 2022 07:05:28 GMT

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!

Re: Count ID's from text

Anonymous — Mon, 11 Apr 2022 10:37:03 GMT

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