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 o...
Need Help
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.