Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
In case there are six spaces in the beginning of my column in PowerQuery, I would like to fill them up with the same six characters as in the row above. Below is an example:
What would I have to do in PowerQuery to make this happen?
Thank you for your help/feedback.
Solved! Go to Solution.
if Text.Contains([Column1] , "-") then Text.BeforeDelimiter([Column1], " -") else null
if Text.Contains([Column1] , "-") then [Column1] else [Custom] & " - " & [Column1]
Hope this helps
Joe
If you found my answer helpful and it solved your issue, please accept as solution
Hi @PowerBI_Consult, do not post same request multiple times please. I've answered here.
Hi @PowerBI_Consult, do not post same request multiple times please. I've answered here.
if Text.Contains([Column1] , "-") then Text.BeforeDelimiter([Column1], " -") else null
if Text.Contains([Column1] , "-") then [Column1] else [Custom] & " - " & [Column1]
Hope this helps
Joe
If you found my answer helpful and it solved your issue, please accept as solution