Remove same text within a column

[SaganBigRedDog]

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 remove that verbage.  However, not all of the record types are the same.  So I basically need a formula that will remove just "Service Onboarding" from the record type name.

I know you can do this in excel, but I'm having trouble finding the same functionality in Power BI.

[vanessafvg · Accepted solution]

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

[v-caliao-msft · Accepted solution]

@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

[u02cm62]

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.

[vanessafvg · Accepted solution]

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