transforming 1 to 001

[Frenk_UM]

I have a column with different numerical values.

For example

1

2

10

100

I want to realise that al numirical values exist of 3 numbers, so it becomes:

1 becomes 001

2 becomes 002

10 becomes 010

100 stays 100

Whats the formula behind this

[barritown · Accepted solution]

Hi @Frenk_UM,

You could do it with this line via DAX:

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

[zenisekd]

In Power Query add a conditional column B, with the following condition:
if Column A <9 then 00,
if Column A < 99 then 0
else null.

Next, you merge the newly created column B with the created column A.

Kudos and mark as solution appreciated.