Number.ToText not creating extra digits

[Anonymous]

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.

[Nathaniel_C · Accepted solution]

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]

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

[Nathaniel_C]

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