{"id":173196,"date":"2026-02-18T11:59:09","date_gmt":"2026-02-18T10:59:09","guid":{"rendered":"https:\/\/liora.io\/en\/?p=173196"},"modified":"2026-02-18T11:59:10","modified_gmt":"2026-02-18T10:59:10","slug":"demystifying-power-bi-date-formats-the-most-commonly-used-formats","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/demystifying-power-bi-date-formats-the-most-commonly-used-formats","title":{"rendered":"Demystifying Power BI Date Formats: The Most Commonly Used Formats"},"content":{"rendered":"<p><strong>Power BI is a business analysis and data modelling service for confident decision-making. By connecting all your data sources at the scale you need, you can visualise and share insights across the whole organisation.<\/strong><\/p>\n<!-- \/wp:post-content -->\n\n<!-- wp:paragraph -->\n<p><a href=\"https:\/\/liora.io\/en\/power-bi-microsofts-business-intelligence-solution\">Power BI is based on the principle of Business Intelligence.<\/a> Many users have difficulty formatting dates in Power BI. Find out how to format the date in Power BI. First, a reminder <a href=\"https:\/\/liora.io\/en\/the-evolution-of-data-insights-data-science-vs-business-intelligence-in-the-big-data-era\">about the tool and Business Intelligence.<\/a><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:heading -->\n<h2 id=\"h-definition-of-business-intelligence\" class=\"wp-block-heading\">Definition of Business Intelligence<\/h2>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p><a href=\"https:\/\/liora.io\/en\/introduction-to-business-intelligence\">The term Business Intelligence (BI)<\/a> refers to the technologies, applications, processes and skills used to collect, integrate, analyse and visualise key information for organisations.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>By analysing large volumes of data and converting it into usable information, Business Intelligence aims to improve decision-making in the commercial, marketing, financial and managerial sectors.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>A variety of data sources are used to create comprehensive tables that facilitate all decision-making processes:<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li><a href=\"https:\/\/liora.io\/en\/customer-segmentation-all-you-need-to-know\">Customer management software (CRM) ;<\/a><\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Supply chain information (suppliers);<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Sales performance;<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>After-sales service performance;<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Marketing expenditure and results;<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Website data;<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>etc.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:paragraph -->\n<p>The benefits of<strong> Business Intelligence<\/strong> are crucial in today&#8217;s organisations. Its tools can speed up the decision-making process, optimise areas where results fall short of expectations, increase team efficiency, generate more revenue and maintain a competitive edge.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><strong>Business Intelligence<\/strong> also has a long-term impact for organisations: it provides an overview of the business over several years, and improves visibility of processes and areas that require particular attention.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:image {\"width\":\"1000px\",\"height\":\"auto\"} -->\n\n<!-- \/wp:image -->\n\n<!-- wp:buttons {\"className\":\"is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\",\"layout\":{\"type\":\"flex\",\"justifyContent\":\"center\"}} -->\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\"><!-- wp:button -->\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/liora.io\/en\/courses\/data-ai\/power-bi\">More information about our Power BI traning<\/a><\/div>\n<!-- \/wp:button --><\/div>\n<!-- \/wp:buttons -->\n\n<!-- wp:heading -->\n<h2 id=\"h-the-main-features-of-power-bi\" class=\"wp-block-heading\">The main features of Power BI<\/h2><!-- wp:image {\"id\":207196,\"sizeSlug\":\"large\"} --><figure class=\"wp-block-image size-large\" style=\"margin-top:var(--wp--preset--spacing--columns);margin-bottom:var(--wp--preset--spacing--columns)\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"572\" src=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-1024x572.jpg\" alt=\"advanced_editor_program.jpg\" class=\"wp-image-207196\" srcset=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-56x56.jpg 56w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-115x64.jpg 115w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-150x150.jpg 150w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-210x117.jpg 210w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-300x167.jpg 300w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-410x270.jpg 410w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-440x246.jpg 440w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-448x448.jpg 448w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-587x510.jpg 587w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-768x429.jpg 768w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-785x438.jpg 785w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-1024x572.jpg 1024w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-1250x590.jpg 1250w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-1440x680.jpg 1440w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-1536x857.jpg 1536w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program-2048x1143.jpg 2048w, https:\/\/liora.io\/app\/uploads\/sites\/9\/2026\/02\/advanced-editor-program.jpg 2560w\" sizes=\"(max-width: 1024px) 100vw, 1024px\"><\/figure><!-- \/wp:image -->\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>With <strong>optimum accessibility<\/strong> and visual presentation, Power BI is an effective business intelligence tool from Microsoft for organisations. It is one of the most widely used tools for analysing and modelling data. Microsoft Power BI is available on computers, smartphones and cloud platforms, enabling company employees to access information and analyse data from anywhere<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><a href=\"https:\/\/liora.io\/en\/power-bi-hubspot-integration-how-do-you-do-it\"> The Power BI tool<\/a> can collect data from multiple sources and formats, including Excel, PDF, CSV, SQL Server, MySQL, Access, XML, JSON and many more. Power BI features include data modelling and a range of visualisation formats. Users can divide voluminous data into several categories, precisely select the possibilities and generate unique tables. Table creators can also <a href=\"https:\/\/liora.io\/en\/exploring-the-boundaries-of-artificial-intelligence\">use artificial intelligence (AI)<\/a> to prepare data, build machine learning models and obtain information from unstructured data. The tool also facilitates the creation of subsets for more detailed analysis of the organisation&#8217;s data.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>Finally, Power BI makes it easy to share information within the company. Reports can be sent to other team members without having to worry about security breaches. It is also possible to define which teams receive which analyses, offering an additional degree of customisation that enhances the organisation&#8217;s overall productivity.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:heading -->\n<h2 id=\"h-changing-the-date-format-in-power-bi\" class=\"wp-block-heading\">Changing the date format in Power BI<\/h2>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>Are you<strong> using Power BI<\/strong> but don&#8217;t know how to change the date format? Discover several options and formats for displaying the date within the tool. To do this:<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li><a href=\"https:\/\/liora.io\/en\/power-bi-desktop-download-and-installation-guide\">Open Power BI on your computer<\/a> and load your data.<br>Make sure your data has a column for dates.*<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>In your Field panel, click on the &#8220;Date&#8221; column. This will open the tools column allowing you to change the date format in Power BI.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>In the &#8220;Format&#8221; section, you can change the date format using the drop-down menu.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>These choices include the popular selection dd\/mm\/yyyy (16-11-2022).<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:paragraph -->\n<p>Sometimes the date format changes when the report is published: the days and months are inverted. To solve this problem, change the default language from English US to English UK.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:image -->\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2023\/11\/format-date-powerbi.jpg\" alt=\"\"><\/figure>\n<!-- \/wp:image -->\n\n<!-- wp:buttons {\"className\":\"is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\",\"layout\":{\"type\":\"flex\",\"justifyContent\":\"center\"}} -->\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\"><!-- wp:button -->\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/liora.io\/en\/courses\/data-ai\/power-bi\">Master date formats on Power BI<\/a><\/div>\n<!-- \/wp:button --><\/div>\n<!-- \/wp:buttons -->\n\n<!-- wp:heading {\"level\":3} -->\n<h3 id=\"h-date-format-in-power-bi-mmm-yy\" class=\"wp-block-heading\">Date format in power BI: mmm-yy<\/h3>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>Changing the date format to mmm-yy (example: Jun 22) is not available in the options in <a href=\"https:\/\/liora.io\/en\/dax-power-bi-all-about-the-query-programming-language\">Power BI. To obtain this display, use a DAX formula.<\/a><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Open Power BI on your computer and load your data.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Click on the &#8220;Modeling&#8221; tab and then click on &#8220;New column&#8221;.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Enter the following DAX formula: Custom Column = FORMAT (&#8216;Orders'[Order Date], &#8220;MMM YY&#8221;).<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:heading {\"level\":3} -->\n<h3 id=\"h-change-date-format-from-yyyymmdd-to-dd-mmm-yyyy\" class=\"wp-block-heading\">Change date format from yyyymmdd to dd mmm yyyy<\/h3>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>The yyyymmdd date format (example: 20220923) is not an optimal display. It&#8217;s much nicer to be able to read the date clearly. To achieve this, create a new <strong>column with a DAX formula.<\/strong><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Click on the &#8220;Modeling&#8221; tab and then on &#8220;New column&#8221;.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Enter the DAX formula: dateFormatted =<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Date(Left([Column Date],4),Right(left([Column Date],6),2),right([Column Date],2)).<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:paragraph -->\n<p>(You can copy and paste the formula directly into Power BI without the full stop at the end of the sentence).<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:heading {\"level\":3} -->\n<h3 id=\"h-date-format-in-power-bi-abbreviation-of-the-month\" class=\"wp-block-heading\">Date format in Power BI: abbreviation of the month<\/h3>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>When you <strong>create a visualization table<\/strong> with the name of each month on the x-axis, some months are likely to take up too much space (like September or November, for example).<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p><strong>It is therefore necessary<\/strong> to use the abbreviation of the months to optimise the display of the table.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>To do this:<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Click on the &#8220;Modeling&#8221; tab and then on &#8220;New column&#8221;.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Enter the<strong> following DAX<\/strong> formula: Short_Name = Format (BIData[Date], &#8220;mmm&#8221;).<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Now add the &#8220;Short_Name(calculated column)&#8221; to the x-axis of the table.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Only the first three letters of each month now appear.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:heading {\"level\":3} -->\n<h3 id=\"h-date-format-in-power-bi-quarter\" class=\"wp-block-heading\">Date format in Power BI: quarter<\/h3>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>If you prefer to group dates by quarter in your views, you will need to use a <strong>DAX formula again.<\/strong> The date 14\/09\/2022 will then appear as follows: Qtr 3 2022.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>Click on the &#8220;Modeling&#8221; tab and then on &#8220;New column&#8221;.<br>Enter the following DAX formula: Column = BIData[Date].[Quarter] &amp;&#8221; &#8221; &amp; BIData[Date].[Year].<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:heading {\"level\":3} -->\n<h3 id=\"h-date-format-in-power-bi-am-pm\" class=\"wp-block-heading\">Date format in Power BI: am pm<\/h3>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>When the time appears in your table, it can take the form of 09:45:00 or 09:45:tt. Let&#8217;s see how to change it by adding AM or PM :<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>Click on the &#8220;Modeling&#8221; tab and then on &#8220;New column&#8221;.<br>Then enter the formula: AM&amp;PM = FORMAT(BIData[Date] , &#8220;m\/dd\/yy h:mm AM\/PM&#8221;).<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>The date will then be displayed as 14\/09\/22 09:45 AM.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:heading {\"level\":3} -->\n<h3 id=\"h-changing-the-date-format-to-months-or-days-of-the-week-in-power-bi\" class=\"wp-block-heading\">Changing the date format to months or days of the week in Power BI<\/h3>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>The process is similar for changing the date format in Power BI to days of the week or sorting dates by month. <strong>Only the DAX formula changes.<\/strong><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>The DAX formula for sorting dates by month: MonthName = FORMAT([Date], &#8220;mmmm&#8221;).<br>The DAX formula for sorting dates by day of the week: Weekdays = FORMAT(BIData[Date], &#8220;DDDD&#8221;).<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:heading {\"level\":3} -->\n<h3 id=\"h-changing-the-date-format-to-text-in-power-bi\" class=\"wp-block-heading\">Changing the date format to text in Power BI<\/h3>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>If you wish to <strong>display dates in text format using Power BI, the method is different.<\/strong><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>In the pane at the top of your screen, click on &#8220;Transform&#8221; to open Power Query Editor.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Here, click on &#8220;Add Column&#8221; and then on &#8220;Custom Column&#8221;.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Name the column (example: &#8220;FormatText&#8221;).<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Then note the following formula: =Date.ToText(DateTime.Date([Date]), &#8220;yyyy-MM-dd&#8221;).<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Check the syntax.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Click OK to validate the formula.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:heading {\"level\":3} -->\n<h3 id=\"h-changing-the-date-format-to-a-number-in-power-bi\" class=\"wp-block-heading\">Changing the date format to a number in Power BI<\/h3>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p>Conversely, you may need the date in text format in Power BI. You will need a dedicated column.<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Click on the &#8220;Modelling&#8221; tab and then &#8220;New Column&#8221;.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Enter the following DAX formula: dateInteger = FORMAT ( [Date], &#8220;YYYYMMDD&#8221; ).<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Then click on the &#8220;Custom Column&#8221; in your Field panel.<\/li>\n<!-- \/wp:list-item -->\n\n<!-- wp:list-item -->\n<li>Change the &#8220;Data type&#8221; to &#8220;Whole number&#8221;.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list -->\n\n<!-- wp:paragraph -->\n<p>You will then have the date in number format: 20220914 (for 14 September 2022).<\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:heading -->\n<h2 id=\"h-conclusion\" class=\"wp-block-heading\">Conclusion<\/h2>\n<!-- \/wp:heading -->\n\n<!-- wp:paragraph -->\n<p><a href=\"https:\/\/liora.io\/en\/power-bi-report-builder-what-is-it-how-do-i-use-it\">Power BI is a business intelligence (BI) tool<\/a> from Microsoft that enables users to collect, model and visualise data from multiple sources and formats to <strong>improve decision-making in organisations.<\/strong> It is possible to change the date format in Power BI by using the date formatting options available in the tool or by creating a new<a href=\"https:\/\/liora.io\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\"> column using a DAX formula.<\/a><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:paragraph -->\n<p>DAX formulas can be used to obtain different date formats, such as the abbreviation of the month, the quarter or the year only. It is also possible to change the default language of the tool to solve the problem of inverting days and months when publishing the report. Using these techniques, you can easily change the date format in <strong>Power BI to improve the presentation of your data.<\/strong><\/p>\n<!-- \/wp:paragraph -->\n\n<!-- wp:buttons {\"className\":\"is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\",\"layout\":{\"type\":\"flex\",\"justifyContent\":\"center\"}} -->\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center\"><!-- wp:button -->\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/liora.io\/en\/courses\/data-ai\/power-bi\">Become an expert on Power BI<\/a><\/div>\n<!-- \/wp:button --><\/div>\n<!-- \/wp:buttons -->\n\n<!-- wp:html -->\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [\n    {\n      \"@type\": \"Question\",\n      \"name\": \"How do you change the date format in Power BI?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"To change the date format in Power BI, load your data, select the date column, then in the Format section choose one of the available formats such as dd\/mm\/yyyy from the dropdown menu.\u00a0([turn0search1])\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"How do you format a date as \u201cmmm\u2011yy\u201d in Power BI?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"To display a date as mmm\u2011yy (like Jun\u00a022), create a new calculated column in the Modeling tab and use a DAX formula such as FORMAT(\u2018Orders'[Order\u00a0Date], \\\"MMM YY\\\").\u00a0([turn0search1])\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"How do you convert yyyymmdd to a readable date in Power BI?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"To convert a yyyymmdd numeric date to dd\u00a0mmm\u00a0yyyy, create a new column and use a DAX formula like Date(Left([Column\u00a0Date],4),Right(left([Column\u00a0Date],6),2),Right([Column\u00a0Date],2)).\u00a0([turn0search1])\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"Can you format Power BI dates by month or day names?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"Yes \u2014 you can format dates by month or day of the week by creating a new column with DAX such as FORMAT([Date], \\\"mmmm\\\") for month names or FORMAT([Date], \\\"DDDD\\\") for day names.\u00a0([turn0search1])\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"How do you display dates with AM\/PM in Power BI?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"To include AM\/PM in the time, add a new calculated column with a formula like FORMAT([Date], \\\"m\/dd\/yy h:mm\u00a0AM\/PM\\\") to show the date and time with AM\/PM.\u00a0([turn0search1])\"\n      }\n    }\n  ]\n}\n<\/script>\n\n<!-- \/wp:html -->","protected":false},"excerpt":{"rendered":"<p>Power BI is a business analysis and data modelling service for confident decision-making. By connecting all your data sources at the scale you need, you can visualise and share insights across the whole organisation. Power BI is based on the principle of Business Intelligence. Many users have difficulty formatting dates in Power BI. Find out [&hellip;]<\/p>\n","protected":false},"author":50,"featured_media":207198,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2433],"class_list":["post-173196","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/173196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=173196"}],"version-history":[{"count":4,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/173196\/revisions"}],"predecessor-version":[{"id":207199,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/173196\/revisions\/207199"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/207198"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=173196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=173196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}