Forum Discussion

SaganBigRedDog's avatar
SaganBigRedDog
Helper I
9 years ago
Solved

Remove same text within a column

I think I'm just having a hard time wording what I'm trying to do.  We have record types that all start with "Service Onboarding" but on my visualizations I think this is redundant so I would like to...
Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    SaganBigRedDog in power query do a replace values (in the transform tab) with nothing

     

     

  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    SaganBigRedDog,

     

    Two DAX expression which can acheive this requirement for you reference.
    Column = REPLACE(Table1[RecordType],1,19,"")

    Column 2 = MID(Table1[RecordType],20,LEN(Table1[RecordType])-19)

     

    Regards,

    Charlie Liao

     

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

SaganBigRedDog,

 

Two DAX expression which can acheive this requirement for you reference.
Column = REPLACE(Table1[RecordType],1,19,"")

Column 2 = MID(Table1[RecordType],20,LEN(Table1[RecordType])-19)

 

Regards,

Charlie Liao

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Why can't you just use "Replace values"?  Meaning why doesn't this work?  It would seem simple enough you would think like Excel values.