Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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.
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.
@frenchiedc87 , refer if this can work https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Hi, In Query Editor, Transform, Extract Text After Delimeter .. Using Delimeter \
Regards
Victor
doesn't work with the direct query mode
the solution doesn't work in direct query mode
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |