HiI 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.

Here is one clickety-click way If you need the orignal also, just duplicate the original column before applying the steps

seprate number with - (dashes) using power query

JorgePinho
Solution Sage
3 years ago
Check this out: https://blog.crossjoin.co.uk/2015/12/03/the-text-format-function-in-power-bipower-query-m/
NishPatel
Resolver II
3 years ago
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.
PaulDBrown
Community Champion
3 years ago
Here is one clickety-click way

If you need the orignal also, just duplicate the original column before applying the steps
- JorgePinho
  Solution Sage
  3 years ago
  Hi PaulDBrown ! Pretty nice demonstration 🙂 Can you tell me which program did you use to record it ?
  - PaulDBrown
    Community Champion
    3 years ago
    Sure!
    
    https://www.screentogif.com/
    
    Downloadable
- lastnn30
  Post Patron
  3 years ago
  Amazing demo, thank you so much all of you.