Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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
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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
91 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |