Forum Discussion
UK Post Codes
Hi there, I have some data that includes full post code, but I'm trying to find a way to just pull the postal area (either first letter or first 2 letters) into a new column. I've looked at LEFT...
Hi Anonymous,
You can also achieve this via creating a calculated column using DAX:
POSTCODEnew = IF ( RIGHT ( LEFT ( 'UK Post Code'[POSTCODEold], 2 ), 1 ) IN { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9" }, LEFT ( 'UK Post Code'[POSTCODEold], 1 ), LEFT ( 'UK Post Code'[POSTCODEold], 2 ) )Best regards,
Yuliana Gu
Still, Power Query would be the more appropriate environment for this kind of transformations.