Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have mailing addresses within a file and I'm trying to check the postal codes to ensure they follow the right format of A#A #A#. With Excel, I'd use the MID formula to return the specific character and manually review. Is there a Power Query function to check the format of postal codes and ensure they follow the guidelines of A#A #A#?
Thank you in advance! I've tried searching for this but couldn't find any solutions.
Solved! Go to Solution.
Hi, @Anonymous
In powerbi, I would suggest you create a calculated column or measure.
You can use the MID function to return the specific character and manually review.
Please check this official document.
You can also try "split" feature in query editor as below:
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
In powerbi, I would suggest you create a calculated column or measure.
You can use the MID function to return the specific character and manually review.
Please check this official document.
You can also try "split" feature in query editor as below:
Best Regards,
Community Support Team _ Eason
Thanks for this! Going to try it out and hopefully can get it to work.
@Anonymous , You can create a string with the format and compare, but not sure that can help https://docs.microsoft.com/en-us/powerquery-m/text-format
Text.Start Text.Middle and Text.End are good to use
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |