cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Seeking advice on date column transformation

I was able to tansform your sample without issue. Not sure if the large file is different in some way.

 

https://www.dropbox.com/s/agrpxnp9ys2zlwd/dates_edit.wmv?dl=1 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Tuffy Member
Member

Re: Seeking advice on date column transformation

Matt,

 

That is so strange why you don't get any error while performing type changes using Locale. I will figure out.

Between, may I know how you enable the two checkboxes (i.e. Column Distribution and Column Quality) as it is cool stuff to find out status of the column. I can't find it Data View pane. Thanks.

 

pic6.JPG

Tuffy Member
Member

Re: Seeking advice on date column transformation

Matt,

 

I am still having error and therefore, I swtich to traditional way by adding three custom columns and breakdown the Transdate into YYYY, MM, DD and later combine them into Date (text) and finally convert it into the proper date format by using Date.FromText function, and it works.

 

I means I can transfer the data in excel but I just want to perform this kinds of activities directly in Query Editor in case the file is too large.

 

I will flag your last feedback as acceped solution and if you don't mind let me now how to pull out those two checkboxes that will be great.

Super User
Super User

Re: Seeking advice on date column transformation

sorry, I was going to mention how to turn it on, but I was running late for a training course.  Go to Options and Settings\Options\Preview Features and turn on column profiling. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Tuffy Member
Member

Re: Seeking advice on date column transformation

I did the enablement in the option setting but the two checkboxes do not display.

Highlighted
Super User
Super User

Re: Seeking advice on date column transformation

Did you restart power BI when prompted?


* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Tuffy Member
Member

Re: Seeking advice on date column transformation

Matt. case closed Smiley Happy

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 381 members 4,157 guests
Please welcome our newest community members: