cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mammifero Frequent Visitor
Frequent Visitor

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.

Immagine.jpg

how i can convert to date format ?

is possible ?

 

Thanks

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User III
Super User III

Re: date conversion from text

@mammifero

 

You can add a New Column for example

 

Column =
DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )
Try my new Power BI game Cross the River

View solution in original post

Super User IV
Super User IV

Re: date conversion from text

Hi,

 

Write this calculated column formula

 

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

 

Format this column as Date.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Super User III
Super User III

Re: date conversion from text

@mammifero

 

You can add a New Column for example

 

Column =
DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )
Try my new Power BI game Cross the River

View solution in original post

Super User IV
Super User IV

Re: date conversion from text

Hi,

 

Write this calculated column formula

 

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

 

Format this column as Date.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

mammifero Frequent Visitor
Frequent Visitor

Re: date conversion from text

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors