undefined

[Akatsuki]

Hello Everyone ,

Am new to Power BI, can anyone please help ?? 

Requirement :- we want to trim the data 

Like :- (1 yr), (11 yr) , (yr) these data should

be removed from the Name column, like below image: -

Please Note :- sometimes middle name, can also be mentioned in the bracket at the last, like third row, but want to keep the full name

 

[tamerj1]

Hi @Akatsuki 

Please try

Expected Name =
VAR String =
    SUBSTITUTE ( 'Table'[Name], " yr", "yr" )
VAR Items =
    SUBSTITUTE ( String, " ", "|" )
VAR Length =
    PATHLENGTH ( Items )
VAR T1 =
    GENERATESERIES ( 1, Length, 1 )
VAR T2 =
    ADDCOLUMNS ( T1, "@Item", [Value] )
VAR T3 =
    FILTER ( T2, NOT CONTAINSSTRING ( [@Item], "yr" ) )
RETURN
    CONCATENATEX ( T3, [@Items], " ", [Value], ASC )

[Akatsuki]

Thank you sir, will try it and let you know

[tamerj1]

@Akatsuki 
Yes but there is still a small problem. I will update the code in my original reply.

[FreemanZ]

hi @Akatsuki 

In Power Query Editor, try to split the name column with the right most (

check more here:

https://learn.microsoft.com/en-us/power-query/split-columns-delimiter

[Akatsuki]

Thank you for replying Sir, But  I want a calculated column using dax function.