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

     

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

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