Grouping Data based on specific string

[sleekpeek]

I have a column called name and the data entry is like this:

YYYYYY-WRLD-TEAMS-TYPES / name

the format is always the same with the same number of digits before the /.

I need to group based on the "types" part of the name as currently they all start with "WEBxx" and are grouped as one value "Website".  I need to split them out so I can plot on a graph e.g.

WEB01

WEB02

WEB03 

and track the numbers/performance as individual items.

How can I achieve this? thanks

[sleekpeek]

thanks for the reply .. it's characters in the middle

YYYYYY-WRLD-TEAMS-"TYPES" / name

also looks like I don't have access to use Power Query Editor ,so will have to ask an admin to create for me.

[danextian]

Hi @sleekpeek ,

If they all start with WEBxx,

DAX calculated column:

Type =
LEFT ( data[column], 5 )

Power Query:

You can extract the first characters and you can either create a new column or transform the existing one.