Forum Discussion

coachbart's avatar
coachbart
Frequent Visitor
5 years ago
Solved

error creating a new column month

Hello,

 

I made a table using calendarauto t make a date table. Creating new columns gives some problems that i don't understand.

 

creating a column

Month = FORMAT('Date'[Date] ; "mm" ) gives an error, change the name to Month1 is the right result. Why?
 
See screenshots:
create date table

create column Month | errorcreate Month1 | good

Need Help

5 Replies

  • coachbart's avatar
    coachbart
    Frequent Visitor
    5 years ago

    Another strange thing. Year = YEAR('Date'[Date]) results 2017 thats fine, change it to jaar = YEAR('Date'[Date]) results in 17.

     

    Reginal settings dutch , source file date format is 17-1-2017 also dutch

     

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    coachbart , I tried on the latest power bi version, This version is working 

    month = FORMAT([Date],"mm")

     

    have you changed any regional settings ?

  • coachbart's avatar
    coachbart
    Frequent Visitor
    5 years ago

    Rebooted PC, everything is suddenly fine.