replace column values using dax

[jitpbi]

Hi,

Is it possible to replace column values using dax (not using power query/tranform data option) for the following column:

Existing Values	New Values
ABC1	1
ABC2	2
ABC3	3
ABC4	4
ABC5	5
ABC6	6
ABC7	7
ABC8	8
ABC9	9
ABC10	10
ABC11	11
ABC12	12

Please suggest how to do this.

Thanks

[v-jingzhang]

Hi @jitpbi 

It is not supported to replace column values with DAX, but you can create a new column with DAX and hide the old column in report view. Right click the old column and check Hide in report view.

New Values = RIGHT('Table'[Existing Values],LEN('Table'[Existing Values])-3)

Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[Tahreem24 · Accepted solution]

@jitpbi ,

Create new Column using below DAX:

New Column = MID(Tbl2[Existing Value],4,LEN(Tbl2[Existing Value]))

Then make this column as Whole number as per the below Screen shot: