Forum Discussion

ShaneL79's avatar
ShaneL79
Helper I
3 years ago
Solved

Leading zeros for alphanumeric columns

Hello Everyone,   I have two different data sources that I am trying to connect using system IDs. The problem is that there is no consistency in how the two departments have named the systems.    ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ShaneL79 ,

     

    Try adding a custom column in the PowerQuery editor:

    if Text.StartsWith([System Names],"0") then Text.Range([System Names],1) else [System Names]

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ShaneL79 ,

 

Try adding a custom column in the PowerQuery editor:

if Text.StartsWith([System Names],"0") then Text.Range([System Names],1) else [System Names]

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

ShaneL79's avatar
ShaneL79
Helper I
3 years ago

Thank you. This worked.