Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Number.ToText not creating extra digits

Hi there,

 

I'm trying to use Number.ToText to add an extra 0 infront of my week numbers that are < 10.

 

I've read that I can put "d2" or "00" for this, but neither are working.  Unfortunately I cannot share the dataset/report due to PI data.  Any advice is greatly appreciated.

 

 

Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    3 years ago

    Hi Anonymous ,
    Try:

    Text.End( "0" & Text.From([Column1]),2)


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

3 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    3 years ago

    Hi Anonymous ,
    Try:

    Text.End( "0" & Text.From([Column1]),2)


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Nathaniel_C , thanks for your reply.  This has indeed worked as intended, thanks buddy 🙂

       

      • Nathaniel_C's avatar
        Nathaniel_C
        Community Champion
        3 years ago

        Hi Anonymous ,
        You are welcome, glad I could help!

        Let me know if you have any questions.

        If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
        Nathaniel