Forum Discussion
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, li...
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 )