how to simplify values in power bi?

[Anonymous]

What I want to do is simplify or make a table with the simplified values.

for example.
I have this table with these value names, but I'm only interested in extracting the numerical value, or text.

something like that.

Numerical values are model identifiers.
How to simplify the values?

so they look like the second table?

[Anonymous · Accepted solution]

If they're ALWAYS <text><number><text> you can, in power query, split the column with SPACE separator and then remove the first and third column.

[Anonymous · Accepted solution]

If they're ALWAYS <text><number><text> you can, in power query, split the column with SPACE separator and then remove the first and third column.

[Tahreem24 · Accepted solution]

Hi,

Go to Power Query Editor then select that column and right click and choose split column then select digit to non-digit option.

Please give Kudos for support and accept this as a solution if it helps you.

[Tahreem24]

After following above step posted by me.. Then keep only that column which has numeric value.

Don't forget to hit Thumbs up!