Forum Discussion

jitpbi's avatar
jitpbi
Post Patron
5 years ago
Solved

replace column values using dax

Hi,

 

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

 

Existing ValuesNew Values
ABC11
ABC22
ABC33
ABC44
ABC55
ABC66
ABC77
ABC88
ABC99
ABC1010
ABC1111
ABC1212

 

Please suggest how to do this.

 

Thanks

Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    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:
     

2 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    5 years ago

    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:
     
  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    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.