Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |