Forum Discussion
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 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
You can add a New Column for example
Column = DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )
Hi,
Write this calculated column formula
=1*("1/"&[MonthNumber]&"/"&[Year])
Format this column as Date.
3 Replies
Hi,
Write this calculated column formula
=1*("1/"&[MonthNumber]&"/"&[Year])
Format this column as Date.
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
You can add a New Column for example
Column = DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )
