Forum Discussion

sleekpeek's avatar
sleekpeek
Regular Visitor
2 years ago

Grouping Data based on specific string

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

Need Help

2 Replies

  • danextian's avatar
    danextian
    Super User
    2 years ago

    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.

     

     

  • sleekpeek's avatar
    sleekpeek
    Regular Visitor
    2 years ago

    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.