Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good morning! I need to replace text at the beginning of a string. I cannot use the REPLACE VALUES function because I have the same text in other cells. I tried using Text.TrimStart in M query but either get an error or just "DIR". See example of data below. End result needed would be ABCD, EFG, HIJK, LMNO DIRECTORATE 2, etc.......
Any assistance would be appreciated.
Solved! Go to Solution.
Create custom column in Power Query
if Text.StartsWith([Column1], "DIR") then Text.AfterDelimiter([Column1]," ") else [Column1]
Create custom column in Power Query
if Text.StartsWith([Column1], "DIR") then Text.AfterDelimiter([Column1]," ") else [Column1]
Thank you!
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |