Forum Discussion

mammifero's avatar
mammifero
Frequent Visitor
7 years ago
Solved

date conversion from text

Good Morning to everyone from Italy apologize for my bad English   i ask for a help or a suggestion. at the end of every month i export from my datawarehouse to Excel two tables with sales inform...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    mammifero

     

    You can add a New Column for example

     

    Column =
DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Write this calculated column formula

     

    =1*("1/"&[MonthNumber]&"/"&[Year])

     

    Format this column as Date.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Write this calculated column formula

 

=1*("1/"&[MonthNumber]&"/"&[Year])

 

Format this column as Date.

  • mammifero's avatar
    mammifero
    Frequent Visitor
    7 years ago

    thanks to all of you for your kindly answers, both working.

     

    last question, if i create a new table "Calendar" with the function "CALENDARAUTO ()" I obtain an error

    message "the function is not able to find a base column DateTime in the model"

     

    i dont understand well why i obtain this error

     

    Regard from Italy

     

    Matteo