topic Re: undefined in DAX Commands and Tips

undefined

Akatsuki — Fri, 07 Apr 2023 06:59:55 GMT

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

Re: undefined

FreemanZ — Fri, 07 Apr 2023 07:35:45 GMT

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

Re: undefined

Akatsuki — Fri, 07 Apr 2023 08:42:12 GMT

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

Re: undefined

tamerj1 — Tue, 11 Apr 2023 07:35:23 GMT

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 )

Re: undefined

Akatsuki — Tue, 11 Apr 2023 07:06:43 GMT

Thank you sir, will try it and let you know

Re: undefined

tamerj1 — Tue, 11 Apr 2023 07:31:37 GMT

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