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.
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
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.