Forum Discussion

Akatsuki's avatar
Akatsuki
Frequent Visitor
3 years ago

undefined

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

 

 

like the image
Want to create a calculated column

5 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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's avatar
      Akatsuki
      Frequent Visitor
      3 years ago

      Thank you sir, will try it and let you know

      • tamerj1's avatar
        tamerj1
        Community Champion
        3 years ago

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

    • Akatsuki's avatar
      Akatsuki
      Frequent Visitor
      3 years ago

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