The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Solved! Go to Solution.
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
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
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
13 | |
13 | |
8 | |
8 |