{"id":178787,"date":"2024-04-03T11:39:55","date_gmt":"2024-04-03T10:39:55","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=178787"},"modified":"2024-07-31T09:47:33","modified_gmt":"2024-07-31T08:47:33","slug":"power-query-date-function-how-do-i-use-it","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it","title":{"rendered":"Power Query Date function: How do I use it?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"178787\" class=\"elementor elementor-178787\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9d02dc3 e-flex e-con-boxed e-con\" data-id=\"9d02dc3\" 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-ccb63c2 elementor-widget elementor-widget-heading\" data-id=\"ccb63c2\" 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 various functions and formulas for using today's date in Power Query, for analysing data in Power BI or Microsoft Excel. Find out everything you need to know about the Power Query Date function.<\/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-a242809 e-flex e-con-boxed e-con\" data-id=\"a242809\" 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-eb5e971 elementor-widget elementor-widget-text-editor\" data-id=\"eb5e971\" 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><a href=\"https:\/\/datascientest.com\/en\/data-analysis-course-face-to-face-or-online-whats-the-best-choice\">In the field of analysis,<\/a> the date is an important piece of information. It contextualises the data in terms of time.<\/p><p>It is therefore an element that must be taken into account to better understand trends, patterns and variations. This makes it possible, for example, to analyse changes in sales, purchasing frequency or productivity within an organisation.<\/p><p>In the course of their work, analysts regularly need to use today&#8217;s date to compare the current trend with a period, or for project management purposes.<\/p><p>In <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\">Excel and Power BI<\/a>, the Power Query data transformation tool allows you to use today&#8217;s date in a number of ways.<\/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-a863cb7 e-flex e-con-boxed e-con\" data-id=\"a863cb7\" 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-22a4af7 elementor-widget elementor-widget-heading\" data-id=\"22a4af7\" 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 and today's date: what's the point about the Power Query Date function?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1e9a5ab elementor-widget elementor-widget-text-editor\" data-id=\"1e9a5ab\" 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>Firstly, <a href=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\">Power Query users can create dynamic filters<\/a> that automatically reflect the current date.<\/p><p>This can be useful when working with data from the current period. For example, to focus on analysing sales for the current month.<\/p><p>It is also possible to track changes in data over time by creating charts and <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\">pivot tables based on the current date.<\/a><\/p><p>For automation purposes, dynamic columns reflecting the current date can be used to create daily reports or update data regularly.<\/p><p>Finally, to track the progress of a project and delivery times in real time, you can also create dynamic columns showing both start and finish dates.<\/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-73a39c9 elementor-widget elementor-widget-image\" data-id=\"73a39c9\" 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\" width=\"2560\" height=\"1707\" src=\"https:\/\/datascientest.com\/en\/files\/2025\/04\/office-employees-working-computers-coworking-desk-with-monitors-1-scaled-1.webp\" class=\"attachment-full size-full wp-image-195238\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2025\/04\/office-employees-working-computers-coworking-desk-with-monitors-1-scaled-1.webp 2560w, https:\/\/datascientest.com\/en\/files\/2025\/04\/office-employees-working-computers-coworking-desk-with-monitors-1-scaled-1-300x200.webp 300w, https:\/\/datascientest.com\/en\/files\/2025\/04\/office-employees-working-computers-coworking-desk-with-monitors-1-scaled-1-1024x683.webp 1024w, https:\/\/datascientest.com\/en\/files\/2025\/04\/office-employees-working-computers-coworking-desk-with-monitors-1-scaled-1-768x512.webp 768w, https:\/\/datascientest.com\/en\/files\/2025\/04\/office-employees-working-computers-coworking-desk-with-monitors-1-scaled-1-1536x1024.webp 1536w, https:\/\/datascientest.com\/en\/files\/2025\/04\/office-employees-working-computers-coworking-desk-with-monitors-1-scaled-1-2048x1366.webp 2048w\" sizes=\"(max-width: 2560px) 100vw, 2560px\" \/>\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-65efba1 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"65efba1\" 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\">\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\">Master Query Date fuction<\/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-913b440 e-flex e-con-boxed e-con\" data-id=\"913b440\" 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-0985b47 elementor-widget elementor-widget-heading\" data-id=\"0985b47\" 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 function for today's date<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9b8014f elementor-widget elementor-widget-text-editor\" data-id=\"9b8014f\" 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>There are two main functions for the current date in Power Query: <strong>Date.LocalNow() and DateTimeZone.LocalNow().<\/strong><\/p><p>The Date.LocalNow() function returns only the current local date, while the DateTimeZoneLocalNow() function also returns the time.<\/p><p>You can use <strong>Date.LocalNow()<\/strong> to create a dynamic column reflecting the current date. For example, you can create a &#8220;Today&#8217;s date&#8221; column in a sales table using the formula &#8220;=Date.LocalNow()&#8221;.<\/p><p>It will automatically be updated to the current date, so you know that the number in the sales column corresponds to the day&#8217;s sales.<\/p><p>Another example is filtering the data in a table to include only records equal to or after the current date and time. This is done using the formula &#8220;= Table.SelectRows(TableName, each [DateColumnName] &gt;= Date.LocalNow())&#8221;.<\/p><p>Similarly, the <strong>&#8216;DateTimeZone.LocalNow()&#8217;<\/strong> function is useful for creating a dynamic column reflecting both the current date and time. For example, the formula &#8216;= DateTimeZone.LocalNow()&#8217; can be used to create a column that is updated automatically each time the data in a connection log table is refreshed.<\/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-6747e85 e-flex e-con-boxed e-con\" data-id=\"6747e85\" 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-8184ed6 elementor-widget elementor-widget-heading\" data-id=\"8184ed6\" 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\">Query editor and current date in the Power Query Date Function<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56d1bea elementor-widget elementor-widget-text-editor\" data-id=\"56d1bea\" 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 you don&#8217;t want to write formulas, you can use the query editor in <a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\">Power Query for Excel and Power BI.<\/a><\/p><p>To add a column with<strong> today&#8217;s date to an Excel table,<\/strong> first open the spreadsheet containing the data.<\/p><p>Click on the &#8220;Data&#8221; tab and select &#8220;From Web&#8221; or &#8220;From File&#8221;. Select the file to be imported and click on &#8216;Open&#8217;, then choose the data to be imported and click on &#8216;Load&#8217;.<\/p><p>In the Power Query editor, click on the &#8220;Add a column&#8221; tab and select &#8220;Today&#8217;s date&#8221;. This column will be added to the query with the current date.<\/p><p>To filter data by today&#8217;s date using the <strong>query editor,<\/strong> click on the arrow next to the column containing the dates you want to filter.<\/p><p>Choose &#8220;Date filters&#8221; and click &#8220;Is after or equal to&#8221;. In the dialogue box that appears, click on &#8216;Today&#8217;s date&#8217; to select the current date. Finally, click OK to apply the filter.<\/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-dabf821 elementor-widget elementor-widget-image\" data-id=\"dabf821\" 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\/date-du-jour-power-query1-e1680170453735.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-9032fc3 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"9032fc3\" 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\">\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\">Become an expert on 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-f9032c0 e-flex e-con-boxed e-con\" data-id=\"f9032c0\" 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-2259d0b elementor-widget elementor-widget-heading\" data-id=\"2259d0b\" 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\">Other date of the day formulas in Power Query Date Function<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ddd8c86 elementor-widget elementor-widget-text-editor\" data-id=\"ddd8c86\" 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 add<strong> days to the current date with the Power Query Date Function<\/strong>, you can use Date.AddDays(). For example, to add 7 days to the current date, the formula is &#8220;= Date.AddDays(Date.LocalNow(), 7)&#8221;.<\/p><p>Similarly, you can add months or years using the Date.AddMonths() and Date.AddYears() functions.<\/p><p>The Date.DayOfWeek() function returns the number of the day of the week for the current date. This is done using the formula &#8220;= Date.DayOfWeek(Date.LocalNow())&#8221;.<\/p><p>Finally, it is possible to return the end date of the month for the current date. The formula to use is &#8220;&#8221;= Date.EndOfMonth(Date.LocalNow())&#8221;.<\/p><p>Once again, these <strong>different functions and formulas<\/strong> can be used to create dynamic columns and filters.<\/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-ca61778 e-flex e-con-boxed e-con\" data-id=\"ca61778\" 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-68f3e3c elementor-widget elementor-widget-heading\" data-id=\"68f3e3c\" 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\">Tips and tricks for the Power Query Date Function<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-63c8f72 elementor-widget elementor-widget-text-editor\" data-id=\"63c8f72\" 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>It is not always necessary to<strong> create a new column containing today&#8217;s date.<\/strong> If you are using a data source that already contains such a column, you can retrieve it with Power Query by selecting it and renaming it if necessary.<\/p><p>Another trick is to change the format of the current date if necessary, using the Date.ToText() function. For example, to display the current date in the format &#8220;dd\/mm\/yyyy&#8221;, use the formula &#8220;= Date.ToText(Date.LocalNow(), &#8220;dd\/MM\/yyyy&#8221;)&#8221;.<\/p><p>Finally, you can use today&#8217;s date as a parameter for dynamic data queries. In the <a href=\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial\">Power Query<\/a> editor, click on &#8216;Manage query parameters&#8217; in the &#8216;Home&#8217; tab. Once you have created the parameter, you can use it in the formulas.<\/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-3591aa2 e-flex e-con-boxed e-con\" data-id=\"3591aa2\" 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-896b9f8 elementor-widget elementor-widget-heading\" data-id=\"896b9f8\" 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 Date Function are an asset for real-time data analysis<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-20a683f elementor-widget elementor-widget-text-editor\" data-id=\"20a683f\" 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 various<strong> Power Query functions and formulas<\/strong> for today&#8217;s date are very useful for updating data in real time or for comparing current trends with the past.<\/p><p>But this is just one of the many <strong>subtleties of Power Query<\/strong>. To fully master this data transformation tool, you can turn to DataScientest.<\/p><p>Our<strong> Power BI training course<\/strong> enables you to learn how to use <a href=\"https:\/\/datascientest.com\/en\/the-evolution-of-data-insights-data-science-vs-business-intelligence-in-the-big-data-era\">Microsoft&#8217;s Business Intelligence<\/a> software in just 5 days. You&#8217;ll learn about Power Query, the <a href=\"https:\/\/datascientest.com\/en\/dax-studio-everything-you-need-to-know-about-the-dax-language-query-analysis-tool\">DAX language,<\/a> Dataviz functionalities and advanced concepts such as DataFlows and incremental updating.<\/p><p>By the end of the course, you&#8217;ll be fully conversant with Power BI for analysing data and creating interactive dashboards. You will then be able to sit the <strong>Microsoft PL-300 exam<\/strong> to obtain Power BI Analyst Associate certification!<\/p><p>All our training courses are distance learning, 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-33bd5d9 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"33bd5d9\" 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\/data-courses\">\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\">More information about 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<div class=\"elementor-element elementor-element-15cbdff elementor-widget elementor-widget-text-editor\" data-id=\"15cbdff\" 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<strong> Power Query&#8217;s current date functions.<\/strong> For more information on the same subject, read our <a href=\"https:\/\/datascientest.com\/en\/getting-started-with-power-bi-online-your-introduction-to-data-visualization\">dossier on 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-b412532 e-flex e-con-boxed e-con\" data-id=\"b412532\" 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-8e8efaf elementor-widget elementor-widget-html\" data-id=\"8e8efaf\" 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\": \"Power Query and today's date: what's the point?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Firstly, Power Query users can create dynamic filters that automatically reflect today's date. This can be useful when working with data from the current period. For example, to focus on analysing sales for the current month. It is also possible to track changes in data over time by creating charts and pivot tables based on the current date.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Power Query functions for today's date\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"There are two main functions for the current date in Power Query: Date.LocalNow() and DateTimeZone.LocalNow(). The Date.LocalNow() function returns only the current local date, while the DateTimeZoneLocalNow() function also returns the time. You can use Date.LocalNow() to create a dynamic column reflecting the current date. For example, you could create a \"Today's date\" column on a sales table using the formula \"=Date.LocalNow()\".\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Other current date formulas\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"To add days to the current date, you can use Date.AddDays(). For example, to add 7 days to the current date, the formula is \"= Date.AddDays(Date.LocalNow(), 7)\". Similarly, you can add months or years using the Date.AddMonths() and Date.AddYears() functions.\"\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 various functions and formulas for using today&#8217;s date in Power Query, for analysing data in Power BI or Microsoft Excel. Find out everything you need to know about the Power Query Date function. In the field of analysis, the date is an important piece of information. It contextualises the data in terms of [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":178808,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420],"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 function: How do I use it?<\/title>\n<meta name=\"description\" content=\"These are just a few examples of the many date functions available in Power Query Date. You can use these functions within ...\" \/>\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-function-how-do-i-use-it\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query Date function: How do I use it?\" \/>\n<meta property=\"og:description\" content=\"There are various functions and formulas for using today&#039;s date in Power Query, for analysing data in Power BI or Microsoft Excel. Find out everything you\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it\" \/>\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-04-03T10:39:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-31T08:47:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/04\/power-query-aktuelles-datum.png\" \/>\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\/png\" \/>\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-function-how-do-i-use-it#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Power Query Date function: How do I use it?\",\"datePublished\":\"2024-04-03T10:39:55+00:00\",\"dateModified\":\"2024-07-31T08:47:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it\"},\"wordCount\":1071,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it\",\"url\":\"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it\",\"name\":\"Power Query Date function: How do I use it?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-04-03T10:39:55+00:00\",\"dateModified\":\"2024-07-31T08:47:33+00:00\",\"description\":\"These are just a few examples of the many date functions available in Power Query Date. You can use these functions within ...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it\"]}]},{\"@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 function: How do I use it?","description":"These are just a few examples of the many date functions available in Power Query Date. You can use these functions within ...","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-function-how-do-i-use-it","og_locale":"en_GB","og_type":"article","og_title":"Power Query Date function: How do I use it?","og_description":"There are various functions and formulas for using today's date in Power Query, for analysing data in Power BI or Microsoft Excel. Find out everything you","og_url":"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-04-03T10:39:55+00:00","article_modified_time":"2024-07-31T08:47:33+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/04\/power-query-aktuelles-datum.png","type":"image\/png"}],"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-function-how-do-i-use-it#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Power Query Date function: How do I use it?","datePublished":"2024-04-03T10:39:55+00:00","dateModified":"2024-07-31T08:47:33+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it"},"wordCount":1071,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it","url":"https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it","name":"Power Query Date function: How do I use it?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-04-03T10:39:55+00:00","dateModified":"2024-07-31T08:47:33+00:00","description":"These are just a few examples of the many date functions available in Power Query Date. You can use these functions within ...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/power-query-date-function-how-do-i-use-it"]}]},{"@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\/178787"}],"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=178787"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178787\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/178808"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=178787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=178787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=178787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}