Normalization text Name

[frenchiedc87]

Can one of you help me figure out how to normalize this data so only the name will show up

Thank You. Greatly appreciate

i:0#.w|qnet\John.doe

i:0#.w|qnet\John.smith

i:0#.w|qnet\bob.hope

[v-xicai · Accepted solution]

Hi @frenchiedc87 ,

You may create a column like DAX below.

Extract Name = RIGHT([Text],LEN([Text])-FIND("\",[Text],1,0))

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@frenchiedc87 , refer if this can work https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[Vvelarde]

@frenchiedc87 

Hi, In Query Editor, Transform, Extract Text After Delimeter .. Using Delimeter \

Regards

Victor

[frenchiedc87]

doesn't work with the direct query mode

[frenchiedc87]

the solution doesn't work in direct query mode