Forum Discussion

JWorthy's avatar
JWorthy
Icon for Advocate I rankAdvocate I
6 years ago
Solved

Formatting Postcodes

Hello,   I have a .csv of delivery information with postcodes that I need to format correctly before I import into Power BI.   Below are the different incorrect ways that postcode information can...
Need Help
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi,

    1. Open Power Query editor.
    2. Select column 'Postal Code_Incorrect (how i receive them)'.
    3. Change data typ to text.
    4. Tab Add Column > Column From Examples
    5. Enter in the first row the postal code A9 9AA, press Enter.
    6. Enter in the second row the postal code A99 9AA, press Enter.
    7. Ok.
    8. Tab Transform > Format > UPPERCASE.
    9. Done!

     

    Regards FrankAT

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try a new column like

new column =left(table[Postal Code],search("9AA",table[Postal Code],1,len(table[Postal Code]))) & " "& if(search("9AA",table[Postal Code],1,-1)>0,"9AA","")

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin