Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Extract Postal Area from UK Postcode

Hi all

 

For a long time I have been using an Excel formula to convert the first half of a UK postcode into its respective postal area code. For example, NE34 become NE.

 

It looks like this, where A2 contains the "NE34", for example: 

 

=LEFT(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789"))-1)

 

Could anyone please advise a DAX equivalent? The MIN function seems to operate differently and I'm stumped.

 

Thanks

  • jthomson's avatar
    jthomson
    8 years ago

    I'd look to do this in a couple of steps - first grab the first two characters using LEFT([yourpostcodefieldname],2), then I'd look to handle the cases where your postcode just has the one letter afterwards - not sure on the best way to do that given there's ten options you want to look for and then remove

     

    edit - searched a bit and this has been asked previously, try having a look at https://community.powerbi.com/t5/Desktop/UK-Post-Codes/td-p/247470

2 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

    I'd look to do this in a couple of steps - first grab the first two characters using LEFT([yourpostcodefieldname],2), then I'd look to handle the cases where your postcode just has the one letter afterwards - not sure on the best way to do that given there's ten options you want to look for and then remove

     

    edit - searched a bit and this has been asked previously, try having a look at https://community.powerbi.com/t5/Desktop/UK-Post-Codes/td-p/247470

  • Sarah87's avatar
    Sarah87
    Regular Visitor
    4 years ago

    Hi I've been trying to use this as per the comments but everytime i enter this expression it gives me various error codes? Brand new to this so apologies if I'm doing somehting silly. Any help you can share would be greatly appreciated, thanks.