Power Query - Pad Text Dynamically
in this Tutorial i show you how to break down a problem into it's components using a record and then figuring out how to pad a field based on where the numbers in the field start.
#excel #powerqueryeditor #powerquery #powerbi #tutorial #powerbidesktop #data #dataanalysis #datacleaning #ETL
File Link
https://github.com/jbotes/powerbiTuto...
Functions used
Text.PositionOfAny to find the position of the numbers
Text.Length to get the length of the field
[] to create records
text.insert to insert text at position
text.repeat to repeat a set number of characters
Noteworthy Mention
Used Records to decompose problem.