Preceeding 0 to Month Number

[Anonymous]

Hi,

Month function giving just Integer values like 1,2,3...How to get like 01,02,03 etc..

FYI , this table we cant see in Query editor as i did this by extracting from other fact table in desktop

[az38]

Hi @Anonymous 

try column

 = FORMAT([DateColumn];"MM")

do not hesitate to kudo useful posts and mark solutions as solution
Linkedin

[Anonymous]

I tried the same. result is same as previous only(1,2,3..)

[az38 · Accepted solution]

@Anonymous 

set Data type as Text in Modeling Ribbon for your new column

do not hesitate to kudo useful posts and mark solutions as solution
Linkedin