{"id":170885,"date":"2023-09-21T20:01:19","date_gmt":"2023-09-21T19:01:19","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=170885"},"modified":"2023-10-30T20:05:21","modified_gmt":"2023-10-30T19:05:21","slug":"power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions","title":{"rendered":"Power BI Time Intelligence: Everything you need to know about these DAX functions"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"170885\" class=\"elementor elementor-170885\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9b8ce75 e-flex e-con-boxed e-con\" data-id=\"9b8ce75\" 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-68c90577 elementor-widget elementor-widget-text-editor\" data-id=\"68c90577\" 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<h2>Power BI is highly useful for comparing two time periods. Thanks to DAX functions and Quick Measures, you can easily compare data for the same period from one year to the next or from the beginning of the year to the current date. Discover everything you need to know about Time Intelligence functions for Power BI.<\/h2>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7443df1a elementor-widget elementor-widget-text-editor\" data-id=\"7443df1a\" 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>Within a<strong> business, it&#8217;s often crucial to compare multiple time periods<\/strong>. This allows for trend analysis or comparisons of sales and financial performance.<\/p><p>However, performing such calculations can be a real challenge when using <a href=\"https:\/\/datascientest.com\/en\/power-bi-report-builder-what-is-it-how-do-i-use-it\">Microsoft Excel formulas and tables. F<\/a>ortunately, Microsoft&#8217;s Power BI business intelligence platform offers features that enable this type of comparison.<\/p><p>Time Intelligence functions assist <a href=\"https:\/\/datascientest.com\/en\/power-bi-microsofts-business-intelligence-solution\">Power BI<\/a> users in performing calculations to evaluate business performance without the need to explicitly store them on a separate sheet for reference.<\/p><p>Time Intelligence calculations <a href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\">using DAX functions and Quick Measures<\/a> are among the most commonly used features in Power BI, particularly for comparing the current period with the previous year.<\/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-7225af75 e-flex e-con-boxed e-con\" data-id=\"7225af75\" 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-65d778ff elementor-widget elementor-widget-heading\" data-id=\"65d778ff\" 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><h3 class=\"elementor-heading-title elementor-size-default\">What are Time Intelligence functions for?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2663bfd8 elementor-widget elementor-widget-text-editor\" data-id=\"2663bfd8\" 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>Businesses often need to evaluate their performance over multiple time periods to compare trends. Decision-makers often want to compare Key Performance Indicators (KPIs) with their annual objectives.<\/p><p>For example, the objective may be to evaluate <strong>Year-to-Date (YTD)<\/strong> profits and adjust the strategy to address any gaps. Comparing the same period from one year to another can also help analyze performance trends.<\/p><p><a href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\">Power BI functions<\/a> provide an efficient way to implement these comparisons through simple calculations. This eliminates the need for complex Excel pivot tables.<\/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-70c96f55 elementor-widget elementor-widget-image\" data-id=\"70c96f55\" 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=\"800\" height=\"319\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/YTD-1024x408.jpg\" class=\"attachment-large size-large wp-image-170890\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/YTD-1024x408.jpg 1024w, https:\/\/datascientest.com\/en\/files\/2023\/09\/YTD-300x120.jpg 300w, https:\/\/datascientest.com\/en\/files\/2023\/09\/YTD-768x306.jpg 768w, https:\/\/datascientest.com\/en\/files\/2023\/09\/YTD.jpg 1049w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2a854cde e-flex e-con-boxed e-con\" data-id=\"2a854cde\" 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-60171749 elementor-widget elementor-widget-heading\" data-id=\"60171749\" 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 BI: compare two periods with Quick Measures<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4cb74f81 elementor-widget elementor-widget-text-editor\" data-id=\"4cb74f81\" 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>Quick Measures in Power BI are an incredibly useful feature that allows you to perform common calculations quickly and easily.<\/p><p>Each Quick Measure consists of a set of DAX queries executed in the background, and the result is displayed directly on the report. This means you don&#8217;t need to write DAX queries yourself. Once created, the Quick Measure is automatically added to the table.<\/p><p>Several Quick Measures are available for common Time Intelligence calculations, such as &#8220;Year-to-date total,&#8221; &#8220;Quarter-to-date total,&#8221; &#8220;Month-to-date total,&#8221; year-over-year changes, or moving averages.<\/p><p>However, for Quick Measures to work, it&#8217;s essential to define a Date table beforehand. You can create this Date table using DAX, Power Query, or SQL.<\/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-5cbc2ca2 e-flex e-con-boxed e-con\" data-id=\"5cbc2ca2\" 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-32d8cc53 elementor-widget elementor-widget-heading\" data-id=\"32d8cc53\" 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 BI: compare two periods with Quick Measures<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-17d8715 elementor-widget elementor-widget-text-editor\" data-id=\"17d8715\" 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>In most cases, when<a href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"> connecting to relational data sources such as SQL Server<\/a>, Oracle, or MySQL, the data model in the Data Warehouse often already contains a Date dimension.<\/p><p>You can simply import the existing<a href=\"https:\/\/datascientest.com\/en\/tutorial-power-bi-learn-how-to-use-the-bi-tool-by-microsoft\"> Date dimension into the Power BI data model.<\/a> This approach has the advantage of establishing a single trusted source for working with dates across the organization.<\/p><p>After connecting Power BI to a data source, you can select the Date table to have a Date dimension within the Power BI data model. This is the simplest and most common way to <a href=\"https:\/\/datascientest.com\/en\/power-bi-license-how-much-does-the-microsoft-solution-cost\">work with time in Power BI.<\/a><\/p><p>If you don&#8217;t have an existing Date dimension to import into your data model, you can easily create one <a href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\">using Power Query<\/a> and its M language. Open a new Power BI file and choose the &#8220;Blank Query&#8221; option under the &#8220;Get Data&#8221; button. You can use parameters to create a flexible and customized Date dimension by selecting &#8220;New Parameter&#8221; in the &#8220;Manage Parameters&#8221; section. Define the start year and end year for your Date dimension.<\/p><p>You can find many<strong> ready-to-use M language<\/strong> scripts on the web to create your Date dimension and incorporate it into the data model. Simply copy and paste the script into the Advanced Editor.<\/p><p>Don&#8217;t forget to save the file in .pbit <strong>(Power BI Template File)<\/strong> format so you can change the time period for which to generate dates.<\/p><p>The third method for creating a Date dimension is to use the DAX language. The CALENDAR() and CALENDARAUTO() functions lay the foundation for all other required attributes such as weeks or business days.<\/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-34a294ce elementor-widget elementor-widget-image\" data-id=\"34a294ce\" 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\" width=\"635\" height=\"277\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/calendar.jpg\" class=\"attachment-large size-large wp-image-170891\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/calendar.jpg 635w, https:\/\/datascientest.com\/en\/files\/2023\/09\/calendar-300x131.jpg 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/>\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-69e1e3b2 elementor-widget elementor-widget-text-editor\" data-id=\"69e1e3b2\" 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>Regardless of the method chosen to <strong>create a Date dimension,<\/strong> it is imperative to mark the table as a Date table. This is what allows you to fully leverage the Time Intelligence functions in DAX.<\/p><p>To be marked as a Date table, the table or column must meet several criteria. It must contain unique values in each row, contiguous values, and the data type must be Date. NULL values are not allowed.<\/p><p>To mark a Date dimension, right-click on it, hover your mouse over the &#8220;Mark as Date Table&#8221; option, and click on it. A dialog box will open, and Power BI will prompt you to select the column to apply the marking to.<\/p><p>The software automatically <strong>recognizes columns with the appropriate data type.<\/strong> As soon as you choose the column, Power BI performs validation. A small icon then appears next to the name of the Date column.<\/p><p>The Date dimension is created and incorporated into your data model. You can now manipulate and compare data for different time periods.<\/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-5ea6450b e-flex e-con-boxed e-con\" data-id=\"5ea6450b\" 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-34fc66e6 elementor-widget elementor-widget-heading\" data-id=\"34fc66e6\" 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\">Compare two periods using DAX functions<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2d31a77 elementor-widget elementor-widget-text-editor\" data-id=\"2d31a77\" 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><a href=\"https:\/\/datascientest.com\/en\/power-bi-vs-tableau\">To compare two periods in Power BI<\/a> without using Quick Measures, the first step is to create a basic measure. For example, you can create a measure to calculate the total sales, and another measure to calculate the total sales for the previous month.<\/p><p>There are different calculation methods available. The DATEADD() function, widely used for working with dates in SQL, provides flexibility for shifted periods.<\/p><p>After creating these basic measures, you can visualize how the figures for two periods are correlated. To simplify the comparison, you can also use data visualizations such as line charts or card visuals.<\/p><p>It&#8217;s also possible to create additional measures to calculate the differences between the periods. Color-coding can be used to show positive changes in one color and negative changes in another.<\/p><p>The SAMEPERIODLASTYEAR() function allows you to compare data for the same period in the previous year. These various DAX functions make it easy to compare different periods.<\/p><p>Furthermore, the<strong> TOTALYTD function allows you to calculate Year-To-Date values easily.<\/strong> This helps evaluate performance from the beginning of the year up to the selected date, making it one of the most commonly used Key Performance Indicators (KPIs) by businesses.<\/p><p>The TOTALMTD and TOTALQTD functions can also indicate Month-to-Date and Quarter-to-Date values to observe the evolution of metrics from the start of the month or quarter to the chosen date.<\/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-3e5ad9c0 elementor-widget elementor-widget-image\" data-id=\"3e5ad9c0\" 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\" width=\"637\" height=\"326\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/totalmtd.jpg\" class=\"attachment-large size-large wp-image-170892\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/totalmtd.jpg 637w, https:\/\/datascientest.com\/en\/files\/2023\/09\/totalmtd-300x154.jpg 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/>\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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-47813a76 e-flex e-con-boxed e-con\" data-id=\"47813a76\" 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-1a53d06f elementor-widget elementor-widget-heading\" data-id=\"1a53d06f\" 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 learn to use Power BI?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7618a17d elementor-widget elementor-widget-text-editor\" data-id=\"7618a17d\" 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 BI is a highly valuable platform for Time Intelligence calculations. Comparing different periods is made easy, often without the need to write a single line of <strong>DAX code.<\/strong><\/p><p>To learn how to navigate Power BI and its various features, you can choose DataScientest. Our training program allows you to master the software in just 38 hours spread over five days.<\/p><p>Beginners can opt for the three-day introductory course, while more experienced users can choose the two-day advanced track.<\/p><p>As a <strong>Microsoft Learning Partner,<\/strong> DataScientest prepares you for the PL-300 certification exam and provides the opportunity to take the test. Upon completion of the course, you will earn the official<strong> Microsoft Power BI Data Analyst Associate certification.<\/strong><\/p><p>This training is entirely conducted online, and our state-recognized organization is eligible for funding through the Compte Personnel de Formation (CPF) for those in France or Bildugsgutschein in Germany. Job seekers may also be eligible for full coverage through P\u00f4le Emploi or the Arbeitsamt. Don&#8217;t wait any longer; discover DataScientest today!<\/p><p>You now have all the information you need about comparing periods with Power BI. For more insights on the same topic,<a href=\"https:\/\/datascientest.com\/en\/power-bi-microsofts-business-intelligence-solution\"> explore our comprehensive guide on Power BI<\/a> or delve into our guide on the DAX language.<\/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-493f32f0 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"493f32f0\" 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\">Power BI 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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-142be7ac e-flex e-con-boxed e-con\" data-id=\"142be7ac\" 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\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>Power BI is highly useful for comparing two time periods. Thanks to DAX functions and Quick Measures, you can easily compare data for the same period from one year to the next or from the beginning of the year to the current date. Discover everything you need to know about Time Intelligence functions for Power [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":170888,"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 BI Time Intelligence: Everything you need to know about these DAX functions<\/title>\n<meta name=\"description\" content=\"When using the Power BI Time Intelligence Functions, you should take into account that in the most cases, these ..\" \/>\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-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI Time Intelligence: Everything you need to know about these DAX functions\" \/>\n<meta property=\"og:description\" content=\"Power BI is highly useful for comparing two time periods. Thanks to DAX functions and Quick Measures, you can easily compare data for the same period from\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\" \/>\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=\"2023-09-21T19:01:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T19:05:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/dax-time-intelligence-fonctions.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"320\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Power BI Time Intelligence: Everything you need to know about these DAX functions\",\"datePublished\":\"2023-09-21T19:01:19+00:00\",\"dateModified\":\"2023-10-30T19:05:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\"},\"wordCount\":1283,\"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-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\",\"url\":\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\",\"name\":\"Power BI Time Intelligence: Everything you need to know about these DAX functions\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-09-21T19:01:19+00:00\",\"dateModified\":\"2023-10-30T19:05:21+00:00\",\"description\":\"When using the Power BI Time Intelligence Functions, you should take into account that in the most cases, these ..\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\"]}]},{\"@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 BI Time Intelligence: Everything you need to know about these DAX functions","description":"When using the Power BI Time Intelligence Functions, you should take into account that in the most cases, these ..","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-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions","og_locale":"en_GB","og_type":"article","og_title":"Power BI Time Intelligence: Everything you need to know about these DAX functions","og_description":"Power BI is highly useful for comparing two time periods. Thanks to DAX functions and Quick Measures, you can easily compare data for the same period from","og_url":"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-09-21T19:01:19+00:00","article_modified_time":"2023-10-30T19:05:21+00:00","og_image":[{"width":640,"height":320,"url":"https:\/\/datascientest.com\/en\/files\/2023\/09\/dax-time-intelligence-fonctions.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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Power BI Time Intelligence: Everything you need to know about these DAX functions","datePublished":"2023-09-21T19:01:19+00:00","dateModified":"2023-10-30T19:05:21+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions"},"wordCount":1283,"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-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions","url":"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions","name":"Power BI Time Intelligence: Everything you need to know about these DAX functions","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-09-21T19:01:19+00:00","dateModified":"2023-10-30T19:05:21+00:00","description":"When using the Power BI Time Intelligence Functions, you should take into account that in the most cases, these ..","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions"]}]},{"@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\/170885"}],"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=170885"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/170885\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/170888"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=170885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=170885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=170885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}