Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi
I have a number like this 123456789. Can I use power query only (no formula) to trasfer it to 123-456-789. Thank you very much for the help in advance.
Solved! Go to Solution.
Here is one clickety-click way
If you need the orignal also, just duplicate the original column before applying the steps
Proud to be a Super User!
Paul on Linkedin.
Here is one clickety-click way
If you need the orignal also, just duplicate the original column before applying the steps
Proud to be a Super User!
Paul on Linkedin.
Amazing demo, thank you so much all of you.
Hi @PaulDBrown ! Pretty nice demonstration 🙂 Can you tell me which program did you use to record it ?
Sure!
Downloadable
Proud to be a Super User!
Paul on Linkedin.
Thank you so much!
In Power Query, Select the number column and select "Split Column" By Positions and enter 3 as number of characters. This will split the number into three columns. Then create custom column and enter formula "Number.ToText([Column1])&"-"&Number.ToText([Column2])&"-"&Number.ToText([Column3]). This will give you your desired result 123-456-789.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
61 | |
61 | |
55 | |
38 | |
27 |
User | Count |
---|---|
85 | |
60 | |
45 | |
41 | |
39 |