Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Preceeding 0 to Month Number

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
6 years ago
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

3 Replies

az38
Community Champion
6 years ago
Hi Anonymous
try column
= FORMAT([DateColumn];"MM")
do not hesitate to kudo useful posts and mark solutions as solution
Linkedin
- Anonymous
  Not applicable
  6 years ago
  I tried the same. result is same as previous only(1,2,3..)
  - az38
    Community Champion
    6 years ago
    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

Related content