topic Re: Creating a new column with only a portion of another in DAX Commands and Tips

Creating a new column with only a portion of another

peterknowlton — Tue, 14 Jun 2022 17:24:50 GMT

For example, one column has

01r01

02r10

05r1

07r9

and I want to create a column that contains only the numbers after the r. So for example,

Re: Creating a new column with only a portion of another

tamerj1 — Tue, 14 Jun 2022 17:36:58 GMT

Hi peterknowlton

please try

MID ( tablename[Column], 4, LEN ( tablename[Column] ) - 3 )

unless it is more complex than the examples.

Re: Creating a new column with only a portion of another

Jihwan_Kim — Tue, 14 Jun 2022 17:37:36 GMT

Hi,

Please check the below picture and the attached pbix file.

It is for creating a calculated column.

Expected column CC = VAR _length = LEN ( Data[ColumnA] ) VAR _locationofR = SEARCH ( "r", Data[ColumnA], 1 ) RETURN RIGHT ( Data[ColumnA], _length - _locationofR )

Re: Creating a new column with only a portion of another

peterknowlton — Tue, 14 Jun 2022 17:47:19 GMT

This is perfect, thank you! One last thing, if I want to include the "r" each time how do I do that?

r01

r10

Re: Creating a new column with only a portion of another

Jihwan_Kim — Tue, 14 Jun 2022 17:57:39 GMT

Hi,

Thank you for your feedback.

Please try the below for creating a calculated column for what you need.

Simply put +1 at the very end of the DAX formula.

Expected column CC = VAR _length = LEN ( Data[ColumnA] ) VAR _locationofR = SEARCH ( "r", Data[ColumnA], 1 ) RETURN RIGHT ( Data[ColumnA], _length - _locationofR +1 )

Re: Creating a new column with only a portion of another

peterknowlton — Tue, 14 Jun 2022 18:00:28 GMT

Thank you, this is perfect!