Power query concatenat leading zero

[dicken]

Hi,
In power query I'd like to add a leading zero to month number below 10, I thought I would just be able to use

0 & Date.Month([date])

, no good did try putting 0 in {} , that didn't work either, is there a way to do this?

 

[alansidman]

I suspect that only way would be if your month value were converted to text.

 

[dicken]

I suspect that only way would be if your month value were converted to text.

Tried that, afraid not. What I wanted this for is as a sort column, I was using year month number, which works up to September but October comes along putting a leading 1 for 10, and so was ranked lower than the 9 for September, so I thought If I added a leading zero it might solve the problem.

 

[dicken]

I suspect that only way would be if your month value were converted to text.

I've found this, I haven't tried it for sorting but i'ts the best I've got so far.

Text.PadStart(Text.From( Date.Month(#date(2000,1,1))),2,"0")

 

[dicken]

I suspect that only way would be if your month value were converted to text.

Final update ;

Table.TransformColumnTypes( 
                               Table.AddColumn(#"Previous step", "Column Name",

                              each Text.PadStart(Text.From( Date.Month( [Date] ) ) ,2,"0")&
                                    Text.From( Date.Year([Date]) )), {  {"Column Name", type number }} )

Richard.

 

[alansidman]

thanks for the feedback

 

[dicken]

thanks for the feedback

No problem.
RD