Change the text format simultaneously into date format in all tables in a dataset

[AKHIL_RB_123]

Hi  Community,

Is it possible to change the text format (date as in text datatype) simultaneously into date format in all tables of the dataset? 

Thanks in Advance.

[Anonymous · Accepted solution]

Hi @AKHIL_RB_123 ,

You can configure automatic data type detection in Power Query for Desktop. After the setup is complete, the next time you connect the data source to Power BI, all data types will be automatically detected and all your dates will be changed to date types.

Reference:

Data types in Power Query - Power Query | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

You can select and change multiple columns at once in the Modeling view:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-modeling-view#setting-common-prope...

For a more automated solution, you'll probably need to do some scripting with a tool like Tabular Editor:

https://docs.tabulareditor.com/te2/Advanced-Scripting.html

[speedramps]

No, you have to change each column in each table.

It is best pratice to use a calendar table with a DateID primary key and display dates, months, quaters and years in your required format.

Then have a DateID foreign key in your fact tables raher than dates.

You then use the relationships to display the calendar dates in the required format, because the formatting is controlled in a central place.

Click here to learn about calendar tables 

Sorry this may not be the answer you want, but it is an answer !

Thanks for reaching out for help.

I put in a lot of effort to help you, now please quickly help me by giving kudos.

Remeber we are unpaid volunteers and here to coach you with Power BI and DAX skills and ttechniques, not do the users job for them !

So plaase click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !