date conversion from text

[mammifero]

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 information that i use to create reports for my CEO.

Now i'm starting to use PowerBI but and i'm a little bit in trouble with the concept of DATE 

i would like to create a calendar table but here's my problem:

the colum Year and Month are text formatted.

how i can convert to date format ?

is possible ?

Thanks

[Zubair_Muhammad · Accepted solution]

@mammifero

You can add a New Column for example

Column =
DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )

[Ashish_Mathur · Accepted solution]

Hi,

Write this calculated column formula

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

Format this column as Date.

[mammifero]

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

[Zubair_Muhammad · Accepted solution]

@mammifero

You can add a New Column for example

Column =
DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )