Solved: Re: Number.ToText not creating extra digits

Anonymous · ‎01-16-2023

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 · ‎01-16-2023

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

View solution in original post

Nathaniel_C · ‎01-16-2023

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Anonymous · ‎01-17-2023

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

Nathaniel_C · ‎01-17-2023

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!