{"id":175819,"date":"2024-01-06T10:31:49","date_gmt":"2024-01-06T09:31:49","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=175819"},"modified":"2024-03-13T18:18:59","modified_gmt":"2024-03-13T17:18:59","slug":"power-query-date-format-how-to-change-it-on-excel-and-power-bi","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi","title":{"rendered":"Power Query Date Format: How to change it on Excel and Power BI"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"175819\" class=\"elementor elementor-175819\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-19b07a8 e-flex e-con-boxed e-con\" data-id=\"19b07a8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2acfd46 elementor-widget elementor-widget-heading\" data-id=\"2acfd46\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">There are different ways to change the Power Query Date Format for Microsoft Excel or Power BI: an indispensable task for data analysis and Business Intelligence. Find out everything you need to know!<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a63b7d8 e-flex e-con-boxed e-con\" data-id=\"a63b7d8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6d49c2b elementor-widget elementor-widget-text-editor\" data-id=\"6d49c2b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>When <a href=\"https:\/\/datascientest.com\/en\/data-sources-understanding-the-definition-and-inner-workings\">collecting data from different sources<\/a>, it&#8217;s not uncommon to be confronted with dates in different formats. This can cause problems.<\/p><p>That&#8217;s why date formatting is an important aspect of data analysis. By performing this task correctly, analysts can better understand temporal trends and improve the relevance of their results.<\/p><p>However, this process can be <strong>tedious and time-consuming.<\/strong> This is particularly the case <a href=\"https:\/\/datascientest.com\/en\/datasets-top-5-places-to-find-quality-datasets\">with large datasets.<\/a><\/p><p>Fortunately, with Microsoft Excel and Power BI, the Power Query <a href=\"https:\/\/datascientest.com\/en\/become-a-data-engineer-the-must-have-skills\">data transformation tool<\/a> makes it easy to change date format. Just follow the guide!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-12476f5 e-flex e-con-boxed e-con\" data-id=\"12476f5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d1254ae elementor-widget elementor-widget-heading\" data-id=\"d1254ae\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What are the different types of date formats for Power Query Date Format?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-454174a elementor-widget elementor-widget-text-editor\" data-id=\"454174a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To begin with, to <strong>understand the importance of date formatting and the Power Query Date Format,<\/strong> we need to go back over the different formats that exist.<\/p><p>We&#8217;re used to the DD\/MM\/YYYY format, typically used in Europe. In the USA, however, the date is traditionally expressed in the order MM\/DD\/YYYY.<\/p><p>In addition to this regional difference, there are also standards for date formats. For example, <strong>ISO 8601 expresses the date as YYYY-MM-DD.<\/strong> It is used in a variety of contexts, including data exchange between computer systems.<\/p><p>However, <a href=\"https:\/\/datascientest.com\/en\/dataiku-a-must-have-tool-for-data-science-and-ai\">when data is analyzed,<\/a> it must be converted to the same format. Otherwise, errors may occur.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c3773ee elementor-widget elementor-widget-image\" data-id=\"c3773ee\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/format-date-power-query.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e14cbf elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"7e14cbf\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn to use Power BI<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-adafe2a e-flex e-con-boxed e-con\" data-id=\"adafe2a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d573e2f elementor-widget elementor-widget-heading\" data-id=\"d573e2f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Change the Power Query Date Format<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2e90d3b elementor-widget elementor-widget-text-editor\" data-id=\"2e90d3b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>Power Query tool<\/strong> allows <a href=\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\">Microsoft Excel and Power BI<\/a> users to format dates in a variety of ways. Here&#8217;s how it works.<\/p><p>First, you need to import data containing dates into Power Query. Then select the date column to be formatted, right-click and choose &#8220;Change type&#8221;.<\/p><p>In the drop-down menu that appears, simply select &#8220;Date&#8221; and choose one of the predefined formats offered: DD\/MM\/YYYY, MM\/DD\/YYYY or YYYY-MM-DD. Click on &#8220;OK&#8221; to save your changes.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8e2e5db e-flex e-con-boxed e-con\" data-id=\"8e2e5db\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e9dc2a2 elementor-widget elementor-widget-heading\" data-id=\"e9dc2a2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I create a custom Power Query date format?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bbcd5a8 elementor-widget elementor-widget-text-editor\" data-id=\"bbcd5a8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>If these predefined formats don&#8217;t meet the user&#8217;s needs, it&#8217;s also possible to <a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\">create customized formats with Power Query.<\/a><\/p><p>The first step is to click on the date column to be formatted, then on &#8220;Add Column&#8221;. Then select &#8220;Custom column&#8221; from the drop-down menu.<\/p><p>A &#8220;Formula&#8221; dialog box then opens, and the user can enter the formula for the desired date format.<\/p><p>For example, to express the date in &#8220;DD\/MM\/YYYY&#8221; format, the appropriate formula is &#8220;=Text.Day([Date])&amp;&#8221;\/&#8221; &amp; Text.Month([Date]) &amp;&#8221;\/&#8221; &amp; Text.Year([Date])&#8221;.<\/p><p>Once the formula has been entered, click on &#8220;OK&#8221;. This saves your changes.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1a21023 e-flex e-con-boxed e-con\" data-id=\"1a21023\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-64f1ec3 elementor-widget elementor-widget-heading\" data-id=\"64f1ec3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Power Query Date Format and the main date format problems<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f0035e elementor-widget elementor-widget-text-editor\" data-id=\"9f0035e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Power Query and the main date format issues However, users may encounter a number of problems.<\/p><p><a href=\"https:\/\/datascientest.com\/en\/what-is-a-dataset-how-do-i-work-with-it\">Firstly, datasets can sometimes contain missing dates.<\/a> It is then necessary to add a column to fill the gaps with a default value.<\/p><p>Similarly, some dates may be invalid. This is the case for dates prior to 1900 or after 9999. To overcome this problem, the solution is to exclude these dates or replace them with a default value.<\/p><p>Another <strong>frequent problem is confusion<\/strong> between the various date formats. For example, if data contains both DD\/MM\/YYYY and MM\/DD\/YYYY dates, this can cause errors. It is therefore essential to ensure that formats are consistent across all data.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f130101 elementor-widget elementor-widget-image\" data-id=\"f130101\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/y5u6O.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f3fb433 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"f3fb433\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn to use Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c94df0d e-flex e-con-boxed e-con\" data-id=\"c94df0d\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ea509df elementor-widget elementor-widget-heading\" data-id=\"ea509df\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What are the best practices for date formatting?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-49a625e elementor-widget elementor-widget-text-editor\" data-id=\"49a625e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To <strong>avoid problems and make the most of the data at their disposal,<\/strong> Power Query users can follow these few tips.<\/p><p>Firstly, make sure you use standardized date formats as often as possible. This <strong>ensures consistency,<\/strong> and facilitates interpretation by other computer systems or applications.<\/p><p>On the other hand, don&#8217;t hesitate to customize date formats to meet specific needs or requirements. Depending on the context, it&#8217;s important to know how to choose the best of these two options.<\/p><p><strong>Before proceeding<\/strong> with the analysis, check carefully that formats are heterogeneous within the dataset. This helps to avoid formatting errors.<\/p><p>Last but not least, <a href=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\">efficient and scalable date formatting<\/a> workflows can be created. This saves time and energy when processing large quantities of data!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e2145fb e-flex e-con-boxed e-con\" data-id=\"e2145fb\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1142dd3 elementor-widget elementor-widget-heading\" data-id=\"1142dd3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion: Power Query simplifies date formatting, provided you know how to use it<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df68862 elementor-widget elementor-widget-text-editor\" data-id=\"df68862\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This article has shown you <strong>how to use Power Query<\/strong> for date formatting in Excel, Power BI and other software compatible with this data transformation tool.<\/p><p>However, in order to exploit all the possibilities offered by Power Query, it is necessary to learn how to master it. This is precisely what DataScientest offers with its Power BI training course.<\/p><p>In this course, you&#8217;ll learn how to use Microsoft&#8217;s Business Intelligence platform and its many features to collect and analyze data and create rich, interactive dashboards.<\/p><p>This course is divided into two parts. The first part, designed for beginners, covers 24 hours over three days, and includes an introduction to Power Query and the <a href=\"https:\/\/datascientest.com\/en\/dax-studio-everything-you-need-to-know-about-the-dax-language-query-analysis-tool\">DAX language.<\/a><\/p><p>The second part lasts 14 hours over 2 days, and is designed to deepen your understanding of the tool. In addition to <a href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\">discovering the subtleties of DAX and Power Query<\/a>, you&#8217;ll also learn advanced concepts such as DataFlows and incremental updating.<\/p><p>In all, the program lasts 38 hours and can be completed in 5 days. Depending on your level and needs, you can take the whole course or choose one of the two parts.<\/p><p>By the end of the course, you will have fully mastered Power BI and Power Query. As a Microsoft Certified Trainer, our organization will accompany you through the Microsoft PL-300 exam and the Power BI Data Analyst Associate certification!<\/p><p>All our training courses are delivered entirely remotely via the Internet, and are eligible for funding options. Discover DataScientest!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5588eb elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"f5588eb\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Start a Power BI training course<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc41c69 elementor-widget elementor-widget-text-editor\" data-id=\"cc41c69\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Now you know all about date formatting with Power Query. For more information on the same subject, take a look at our complete <a href=\"https:\/\/datascientest.com\/en\/getting-started-with-power-bi-online-your-introduction-to-data-visualization\">guide to Power BI.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0dd9fb4 e-flex e-con-boxed e-con\" data-id=\"0dd9fb4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8e220c3 elementor-widget elementor-widget-html\" data-id=\"8e220c3\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\" : \"https:\/\/schema.org\",\n  \"@type\" : \"FAQPage\",\n  \"mainEntity\" : [{\n    \"@type\" : \"Question\",\n    \"name\" : \"What are the different types of date formats?\",\n    \"acceptedAnswer\" : {\n      \"@type\" : \"Answer\",\n      \"text\" : \"As a preamble, to understand the importance of date formatting, we need to go back over the different existing formats. We're used to the DD\/MM\/YYYY format, typically used in Europe. In the USA, on the other hand, dates are traditionally expressed in the order MM\/DD\/YYYY.\"\n    }\n  },{\n    \"@type\" : \"Question\",\n    \"name\" : \"How do I create a custom date format?\",\n    \"acceptedAnswer\" : {\n      \"@type\" : \"Answer\",\n      \"text\" : \"If these predefined formats don't meet the user's needs, it's also possible to create custom formats with Power Query. The first step is to click on the date column to be formatted, then on \"Add Column\". Then select \"Custom column\" from the drop-down menu. A \"Formula\" dialog box then opens, and the user can enter the formula for the desired date format.\"\n    }\n  },{\n    \"@type\" : \"Question\",\n    \"name\" : \"What are the best practices for date formatting?\",\n    \"acceptedAnswer\" : {\n      \"@type\" : \"Answer\",\n      \"text\": \"To avoid problems and take full advantage of the data at hand, Power Query users can follow these tips. First of all, make sure you use standardized date formats as often as possible. This ensures consistency and facilitates interpretation by other computer systems or applications. On the other hand, don't hesitate to customize date formats to meet specific needs or requirements. Depending on the context, it's important to know how to choose the best of these two options.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>There are different ways to change the Power Query Date Format for Microsoft Excel or Power BI: an indispensable task for data analysis and Business Intelligence. Find out everything you need to know! When collecting data from different sources, it&#8217;s not uncommon to be confronted with dates in different formats. This can cause problems. That&#8217;s [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":175820,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power Query Date Format: How to change it on Excel and Power BI<\/title>\n<meta name=\"description\" content=\"Power Query Date Format: In both Excel and Power BI, you can use Power Query to modify the date format. Power Query provides a user-friendly interface to\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query Date Format: How to change it on Excel and Power BI\" \/>\n<meta property=\"og:description\" content=\"There are different ways to change the Power Query Date Format for Microsoft Excel or Power BI: an indispensable task for data analysis and Business\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-06T09:31:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-13T17:18:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/format-date-Power-Query.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Power Query Date Format: How to change it on Excel and Power BI\",\"datePublished\":\"2024-01-06T09:31:49+00:00\",\"dateModified\":\"2024-03-13T17:18:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\"},\"wordCount\":1005,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\",\"url\":\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\",\"name\":\"Power Query Date Format: How to change it on Excel and Power BI\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-06T09:31:49+00:00\",\"dateModified\":\"2024-03-13T17:18:59+00:00\",\"description\":\"Power Query Date Format: In both Excel and Power BI, you can use Power Query to modify the date format. Power Query provides a user-friendly interface to\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Query Date Format: How to change it on Excel and Power BI","description":"Power Query Date Format: In both Excel and Power BI, you can use Power Query to modify the date format. Power Query provides a user-friendly interface to","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi","og_locale":"en_GB","og_type":"article","og_title":"Power Query Date Format: How to change it on Excel and Power BI","og_description":"There are different ways to change the Power Query Date Format for Microsoft Excel or Power BI: an indispensable task for data analysis and Business","og_url":"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-06T09:31:49+00:00","article_modified_time":"2024-03-13T17:18:59+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/format-date-Power-Query.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Power Query Date Format: How to change it on Excel and Power BI","datePublished":"2024-01-06T09:31:49+00:00","dateModified":"2024-03-13T17:18:59+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi"},"wordCount":1005,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi","url":"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi","name":"Power Query Date Format: How to change it on Excel and Power BI","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-06T09:31:49+00:00","dateModified":"2024-03-13T17:18:59+00:00","description":"Power Query Date Format: In both Excel and Power BI, you can use Power Query to modify the date format. Power Query provides a user-friendly interface to","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/175819"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=175819"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/175819\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/175820"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=175819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=175819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=175819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}