How to extract string from name and create product group

[asalazarjr]

Hey All,
Need help creating dax formula or calculated column to extract product density. Any help is greatly appreciated!

Need to go from left product column to right density group:

Product	Density
A123 B1234 8Gbit 8 77/999 AE 1 AB	8Gbit
A123 B12 4Gbit 16 7/999 ABCDE 1 AB	4Gbit
A123 B1 2Gbit 16 77/999 AB 1 AB	2Gbit
A123 B12346 512Gbit 8 77/99 ABCDE	512Gbit
A123 B123 77/999 ABCDE 1TB	1TB

Thanks in advance!

[jewel_at]

Hi @asalazarjr 

I would recommend extracting the string in Power Query instead, you can use BetweenDelimiters function:

= Table.AddColumn(#"Changed Type", "Density", each if Text.Contains([Product], "TB") = true then Text.BetweenDelimiters([Product], " "," ", 3,0) else if Text.Contains([Product], "Gbit") = true then Text.BetweenDelimiters([Product], " "," ",1,0) else "")

This is based on the sample data that you have.

Hope this helps!

Jewel 

[amitchandak · Accepted solution]

@asalazarjr , Power query Text between delimiter, skip 1 from beginning

https://learn.microsoft.com/en-us/powerquery-m/text-betweendelimiters

https://radacad.com/extract-parts-of-a-text-value-in-power-bi-using-a-delimiter-power-query-transfor...

https://youtu.be/oGY4RoPKDOE