How to group data for use in a pivot table

[Juanjoge]

Hello, I have data where I have 4 records that start with the same name, but the difference is an additional text to recognize who they belong (see figure), how can I do so that in the selection list appear grouped to treat them as a single data, is it possible?

Thank you very much for your support

[v-eachen-msft · Accepted solution]

Hi @Juanjoge .

You could refer to the following DAX:

Column =
VAR a =
    SEARCH ( " ", 'Table'[Records], 1, 0 )
RETURN
    IF ( a > 0, LEFT ( 'Table'[Records], a - 1 ), 'Table'[Records] )

Here is my test result.

[amitchandak]

@Juanjoge , refer if this can help

https://www.poweredsolutions.co/2019/03/26/fuzzy-matching-in-power-bi-power-query/

https://www.youtube.com/watch?v=I65YCrJWliw

[parry2k]

@Juanjoge well you have to group these together, are these only 3 values you need to group

New Column=
IF (Containsstring(Table[Column], "Mining City", "Mining City",Table[Column] )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!