Forum Discussion
Normalization text Name
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 |
Hi Anonymous ,
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.
5 Replies
Hi Anonymous ,
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.
Anonymous
Hi, In Query Editor, Transform, Extract Text After Delimeter .. Using Delimeter \
Regards
Victor
Anonymous , refer if this can work https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
