Changing date format in Power Query Editor

Hi Anonymous ,

 

---

 

I wanted to change date format (DD-MM-YYYY) into (YYYY-MM-DD) in Power Query Editor

 

---

Why do you want to change date format from DD-MM-YYYY to YYYY-MM-DD? 

 

If you want to keep the data type as "Date", it is no need to manually change it in Power Query Editor. It is based on your local machine's date formate. 

 

 

You can change it in Power BI Desktop later.

 

If you want to keep the data type as text and since your date column has changed to "Date" type, create a custom column like this:

Text.From(Date.Year([Date])) & "-" & Text.From(Date.Month([Date])) & "-" & Text.From(Date.Day([Date]))

 

 

Best Regards,

Icey

 

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