cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Guinaba Regular Visitor
Regular Visitor

Not able to convert to date format

Hello experts:

 

I am trying to merge 3 columns in one converting the final result into date format.

1) Merging the columns: StartDate=[Start date.2.2]/[Start date.2.1]/[Start date.2.3]

2) Converting to Date format

 

However the final result is messed up! The dates don't match against the original data.

Would someone have any suggestion? How to do that?

1) Merging these 3 cols:

Pic1.jpgPic2.jpgPic3.jpgPic4.jpg

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Guinaba Regular Visitor
Regular Visitor

Re: Not able to convert to date format

Thanks @erik_tarnvik! Much appreciate it!!

View solution in original post

3 REPLIES 3
Highlighted
erik_tarnvik Established Member
Established Member

Re: Not able to convert to date format

In Power Query you must use the functions available in the Power Query language (sometimes called M). If your columns are numbers, your formula is a division, not a concatenation of strings.

 

Try writing the same as this:

= Text.From([Start date.2.2]) & "/" & 
Text.From([Start date.2.1]) & "/" &
Text.From([Start date.2.3])
erik_tarnvik Established Member
Established Member

Re: Not able to convert to date format

Or if you want the column to conatin an actual date rather than a text string representing a date, try

= #date([Start date.2.3],[Start date 2.1],[Start date 2.2])  

 

Guinaba Regular Visitor
Regular Visitor

Re: Not able to convert to date format

Thanks @erik_tarnvik! Much appreciate it!!

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 484 members 4,615 guests
Please welcome our newest community members: