Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

UK PostCode to Area Code

Hi,   I would like to break down the UK postcode into an area code. For example, SE27 9HR to SE27.    I found a solution for a DAX command to return the first 2 characters (in this case SE) but I...
Need Help DAX
  • goncalogeraldes's avatar
    goncalogeraldes
    4 years ago

    Hello there Anonymous ! Wouldn't it be easier for you to do this in Power Query Editor with either the "split column" function or the "extract" function? 

     

     

    Alternatively, you can also try this!

     

    ColumnB = 
Var FirstSpace = FIND(" ";'UK Post Code'[POSTCODEold]) 
Return 
LEFT('UK Post Code'[POSTCODEold]; LEN('UK Post Code'[POSTCODEold]) - FirstSpace)

     

    Hope this answer solves your problem! If you need any additional help please tag me in your reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
    Thanks!

    Best regards,
    Gonçalo Geraldes 

goncalogeraldes's avatar
goncalogeraldes
Super User
4 years ago

Hello there Anonymous ! Wouldn't it be easier for you to do this in Power Query Editor with either the "split column" function or the "extract" function? 

 

 

Alternatively, you can also try this!

 

ColumnB = 
Var FirstSpace = FIND(" ";'UK Post Code'[POSTCODEold]) 
Return 
LEFT('UK Post Code'[POSTCODEold]; LEN('UK Post Code'[POSTCODEold]) - FirstSpace)

 

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes