{"id":46327,"date":"2025-01-21T21:26:46","date_gmt":"2025-01-21T16:26:46","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=46327"},"modified":"2026-01-29T17:25:02","modified_gmt":"2026-01-29T12:25:02","slug":"datediff-in-power-bi","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/datediff-in-power-bi","title":{"rendered":"Datediff in Power BI Visualizing Time Data Easily"},"content":{"rendered":"<p>Power BI is arguably the best data analytics tool that gives users room to generate insightful visualizations and reports. With the Power BI tool, users can easily calculate date and time differences.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/datediff-in-power-bi.jpg\" alt=\"Datediff in Power BI\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MjkrQ29tcGFyaXNvbis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTcyOSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTcyOSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>The DATEDIFF in Power BI is one of the essential time-related functions. In this guide, you\u2019ll discover what the datediff Power BI is, why datediff in Power BI is important, and also get a good grasp of the datediff function in Power BI.<\/p>\n<h3>Table of Contents:<\/h3>\n<ol>\n<li><a href=\"#what-is-the-datediff-in-power-bi\">What is the Datediff in Power BI?<\/a><\/li>\n<li><a href=\"#why-is-datediff-in-power-bi-important\">Why is Datediff in Power BI Important?<\/a><\/li>\n<li><a href=\"#what-are-the-tips-for-using-datediff-in-power-bi\">What are the Tips for Using Datediff in Power BI?<\/a><\/li>\n<li><a href=\"#how-to-use-datediff-in-power-bi\">How to Use Datediff in Power BI?<\/a><\/li>\n<li><a href=\"#visualize-datediff-in-power-bi\">How to Visualize Datediff in Power BI?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>First&#8230;<\/p>\n<h2 id=\"what-is-the-datediff-in-power-bi\">What is the Datediff in Power BI?<\/h2>\n<p>Power BI users often have to calculate the time differences between two dates in a table. It\u2019s a complex task, but all the user has to do is use the DAX DATEDIFF formula.<\/p>\n<p>You only have to know what the start and end points are in date (or time) format. You also have to specify the type of interval you want.<\/p>\n<p>The DAX DATEDIFF function calculates the time interval between two dates (<a href=\"https:\/\/chartexpo.com\/blog\/no-of-days-between-two-dates\" target=\"_blank\" rel=\"noopener\">No of Days Between Two Dates<\/a>). It presents the results in seconds, minutes, hours, days, weeks, months, quarters, or years.<\/p>\n<p>The syntax of Power BI DATEDIFF is: \u201cDATEDIFF (Start Date, End Date, Interval).\u201d<\/p>\n<p>The &#8220;start date&#8221; and &#8220;end date&#8221; parameters are scalar date (or time) values. The &#8220;interval&#8221; parameter is the interval to be used to compare dates, and it could be &#8216;SECONDS,&#8217; &#8216;MINUTES,&#8217; &#8216;HOUR,&#8217; &#8216;DAY,&#8217; &#8216;WEEK,&#8217; &#8216;MONTH,&#8217; &#8216;QUARTER,&#8217; or &#8216;YEAR.&#8217;<\/p>\n<h2 id=\"why-is-datediff-in-power-bi-important\">Why is Datediff in Power BI Important?<\/h2>\n<p>The DATEDIFF function in Power BI is important because it helps users analyze time-based data effectively by calculating the difference between two dates in various units (such as days, months, or years). This function is crucial for:<\/p>\n<ul>\n<li><strong>Time-based Analysis:<\/strong> Power BI plays a vital role in <a href=\"https:\/\/chartexpo.com\/blog\/what-is-business-intelligence\" target=\"_blank\" rel=\"noopener\">business intelligence<\/a> and reporting. It helps <a href=\"https:\/\/chartexpo.com\/blog\/trend-analysis\" target=\"_blank\" rel=\"noopener\">analyze trends<\/a> over time. With DATEDIFF, you can calculate the duration between two dates in a meaningful way, and that allows the user to gain insights into patterns, trends, and performance over time.<\/li>\n<li><strong>Date Filtering:<\/strong> Filtering data based on date ranges is common among users within the Power BI ecosystem. DATEDIFF helps filter data dynamically, and that gives users room to focus on specific time periods in the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-report-examples\" target=\"_blank\" rel=\"noopener\">Power BI reports<\/a>.<\/li>\n<li><strong>Date Aggregation:<\/strong> There are cases where you&#8217;ll need to aggregate data based on time intervals like calculating the total sales for each month, quarter, or year. DATEDIFF plays a crucial role in determining the difference in months (or years) between dates, and that facilitates these <a href=\"https:\/\/chartexpo.com\/blog\/what-is-aggregated-data\" target=\"_blank\" rel=\"noopener\">data aggregations<\/a>.<\/li>\n<li><strong>Forecasting and Planning:<\/strong> To get the most out of forecasting and planning, you need to have a good grasp of the time intervals between events (or milestones). DATEDIFF helps calculate these intervals, and that allows for <a href=\"https:\/\/chartexpo.com\/blog\/data-driven-decision-making\" target=\"_blank\" rel=\"noopener\">data-driven decision-making<\/a>.<\/li>\n<li><strong>Age Calculation:<\/strong> In cases where age is relevant (like workforce management or <a href=\"https:\/\/chartexpo.com\/blog\/customer-behavior-analytics\" target=\"_blank\" rel=\"noopener\">customer analytics<\/a>), DATEDIFF can be used to calculate individual ages by finding the difference between their birthdate and the current date.<\/li>\n<\/ul>\n<h2 id=\"what-are-the-tips-for-using-datediff-in-power-bi\">What are the Tips for Using Datediff in Power BI?<\/h2>\n<p>Here are some useful tips for using the DATEDIFF function in Power BI effectively:<\/p>\n<ul>\n<li><strong>Understand the Syntax:<\/strong> You need to have a good grasp of the syntax of the DATEDIFF function, and that includes the order of arguments (like the start date, time unit, and end date). This helps in accurate calculations.\n<ul>\n<li>DATEDIFF (start date, end date, time unit).<\/li>\n<\/ul>\n<\/li>\n<li><strong>Handle Null or Blank Dates:<\/strong> Check for blank or null dates before using DATEDIFF to avoid unexpected results. You should use conditional logic (or the IF function) to appropriately handle these issues.<\/li>\n<li><strong>Use Meaningful Time Units:<\/strong> Choose the time unit that makes the most sense for the <a href=\"https:\/\/chartexpo.com\/blog\/data-analysis\" target=\"_blank\" rel=\"noopener\">data analysis<\/a>. Common units include \u201cday,\u201d \u201cmonth,\u201d \u201cquarter,\u201d and \u201cyear.\u201d You should know that different units may yield different results.<\/li>\n<li><strong>The Date Formats must be Consistent:<\/strong> You should ascertain that the date columns have consistent formats. Inconsistent date formats could lead to errors (or unexpected results) when using DATEDIFF.<\/li>\n<li><strong>Use with Time Intelligence Functions:<\/strong> You can use the DATEDIFF in conjunction with other time intelligence functions in Power BI. These time intelligence functions could be TOTALMTD, TOTALQTD, and TOTALYTD, for advanced time-based analysis.<\/li>\n<\/ul>\n<h2 id=\"how-to-use-datediff-in-power-bi\">How to Use Datediff in Power BI?<\/h2>\n<p>Here are easy steps to help you use DATEDIFF in Power BI:<\/p>\n<h3>Using DATEDIFF in a Calculated Column:<\/h3>\n<ul>\n<li>Open Power BI Desktop:<\/li>\n<\/ul>\n<p>Launch the Power BI Desktop and open the Power BI file (or connect to the data source).<\/p>\n<ul>\n<li>Navigate to the \u201cData\u201d view to see the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-data-model\" target=\"_blank\" rel=\"noopener\">data model<\/a>.<\/li>\n<li>Select or Create a Table:<\/li>\n<\/ul>\n<p>Select the table you want to create the calculated column or measure.<\/p>\n<ul>\n<li>New Column:<\/li>\n<\/ul>\n<p>Click on \u201cNew Column\u201d in the ribbon under the \u201cModeling\u201d tab.<\/p>\n<ul>\n<li>Write the DATEDIFF formula in the formula bar. For instance, to calculate the difference in days between two date columns.\n<ul>\n<li>DaysDifference = DATEDIFF(\u2019YourTable\u2019[StartDate], \u2018YourTable\u2019[EndDate], DAY)<\/li>\n<\/ul>\n<\/li>\n<li>Press Enter to create the new column. After that, Power BI will calculate the values based on the DATEDIFF formula.<\/li>\n<li>Navigate to the \u201cData\u201d view and check the values in the newly created column to ascertain that they match your expectations.<\/li>\n<\/ul>\n<h3>Using DATEDIFF in a Measure:<\/h3>\n<p>Here are the steps to follow when using the Power BI datediff measure:<\/p>\n<ul>\n<li>New Measure:<\/li>\n<\/ul>\n<p>Click on \u201cNew Measure\u201d in the ribbon under the \u201cModeling\u201d tab.<\/p>\n<ul>\n<li>Write the DATEDIFF Formula:<\/li>\n<\/ul>\n<p>Navigate to the formula bar, and write the DATEDIFF formula. For instance, to calculate the difference in days between two date columns:<\/p>\n<ul>\n<li>DaysDifference = DATEDIFF(MAX(\u2019YourTable\u2019[StartDate]), MAX(\u2019YourTable\u2019[EndDate]), DAY)<\/li>\n<\/ul>\n<p>Press Enter to create a new measure. After that, Power BI will calculate the values based on the DATEDIFF formula at runtime. This measure can be used in visuals like charts, graphs, tables, or cards to display the calculated difference dynamically.<\/p>\n<p>Examples:<\/p>\n<ul>\n<li>In Power BI Desktop, Click on Data Mode.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/in-power-bi-desktop-click-on-data-mode-for-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/in-power-bi-desktop-click-on-data-mode-for-doing-datediff-in-power-bi.jpg\" alt=\"In Power BI Desktop Click on Data Mode for Doing Datediff in Power BI\" width=\"537\" \/><\/a><\/div>\n<ul>\n<li>Navigate to the left side, and click on the table you want to add a new column.<\/li>\n<li>In the &#8220;Table Tools&#8221; tab, click on &#8220;New Column&#8221; to create a new Column using <a href=\"https:\/\/chartexpo.com\/blog\/what-is-dax-in-power-bi\" target=\"_blank\" rel=\"noopener\">DAX<\/a>.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-new-column-for-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-new-column-for-doing-datediff-in-power-bi.jpg\" alt=\"Click on New Column for Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Write the formula below to calculate DATE differences between two dates in YEAR using DAX DATEDIFF in Power BI.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/write-formula-below-to-calculate-date-differences-for-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/write-formula-below-to-calculate-date-differences-for-doing-datediff-in-power-bi.jpg\" alt=\"Write Formula Below to Calculate Date Differences for Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/using-dax-datediff-for-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/using-dax-datediff-for-doing-datediff-in-power-bi.jpg\" alt=\"Using DAX DATEDIFF for Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>The resultant columns are shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/resultant-columns-for-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/resultant-columns-for-doing-datediff-in-power-bi.jpg\" alt=\"Resultant Columns for Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can also create a Quarter.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/create-quarters-for-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/create-quarters-for-doing-datediff-in-power-bi.jpg\" alt=\"Create Quarters for Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can create a number of months.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/create-number-of-months-for-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/create-number-of-months-for-doing-datediff-in-power-bi.jpg\" alt=\"Create Number of Months for Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Write the below formula to calculate DATE differences between two dates in Days using DAX DATDIFF in Power BI.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/calculate-data-differences-for-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/calculate-data-differences-for-doing-datediff-in-power-bi.jpg\" alt=\"Calculate DATA Differences for Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<p>To calculate minutes or seconds, you\u2019ll have to change the time interval parameter. For instance:<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-time-interval-parameter-for-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/change-time-interval-parameter-for-doing-datediff-in-power-bi.jpg\" alt=\"Change Time Interval Parameter for Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<h2 id=\"visualize-datediff-in-power-bi\">How to Visualize DATEDIFF in Power BI?<\/h2>\n<p>Learn how to visualize DATEDIFF calculations in Power BI effectively using <a href=\"https:\/\/chartexpo.com\/tools\/power-bi-custom-visuals\" target=\"_blank\" rel=\"noopener\">Power BI charts<\/a> to gain clear insights from your data.<\/p>\n<h3>Stage 1: Log into Power BI, enter your email, and click \u201cSubmit.\u201d<\/h3>\n<ul>\n<li>Log in to Power BI.<\/li>\n<li>Enter your email address and click the \u201c<strong>Submit<\/strong>\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\" alt=\"Enter email to login to Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You are redirected to your Microsoft account.<\/li>\n<li>Enter your password and click \u201c<strong>Sign in<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\" alt=\"Enter Password to login to Power BI\" width=\"363\" \/><\/a><\/div>\n<ul>\n<li>You can choose whether to stay signed in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\" alt=\"Click on stay signed in\" width=\"392\" \/><\/a><\/div>\n<ul>\n<li>Once done, the Power BI home screen will open.<\/li>\n<\/ul>\n<h3>Stage 2: Create a Data Set and Select the Data Set to Use in the Sankey Chart<\/h3>\n<ul>\n<li>Go to the left-side menu and click the \u201c<strong>Create<\/strong>\u201d button.<\/li>\n<li>Select \u201c<strong>Paste or manually enter data<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\" alt=\"select Paste or manually enter data in Power BI ce487\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MjkrQ29tcGFyaXNvbis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTcyOSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTcyOSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<ul>\n<li>We&#8217;ll use the <a href=\"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi\" target=\"_blank\" rel=\"noopener noreferrer\">sample data<\/a> below for this example.<\/li>\n<\/ul>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td>Quarters<\/td>\n<td>Vendors<\/td>\n<td>Market Share<\/td>\n<\/tr>\n<tr>\n<td>Q1<\/td>\n<td>Samsung<\/td>\n<td>27.69<\/td>\n<\/tr>\n<tr>\n<td>Q1<\/td>\n<td>Apple<\/td>\n<td>28.45<\/td>\n<\/tr>\n<tr>\n<td>Q1<\/td>\n<td>Xiaomi<\/td>\n<td>11.8<\/td>\n<\/tr>\n<tr>\n<td>Q1<\/td>\n<td>Huawei<\/td>\n<td>6.53<\/td>\n<\/tr>\n<tr>\n<td>Q1<\/td>\n<td>Oppo<\/td>\n<td>5.3<\/td>\n<\/tr>\n<tr>\n<td>Q1<\/td>\n<td>Vivo<\/td>\n<td>4.19<\/td>\n<\/tr>\n<tr>\n<td>Q2<\/td>\n<td>Samsung<\/td>\n<td>28.14<\/td>\n<\/tr>\n<tr>\n<td>Q2<\/td>\n<td>Apple<\/td>\n<td>27.58<\/td>\n<\/tr>\n<tr>\n<td>Q2<\/td>\n<td>Xiaomi<\/td>\n<td>12.62<\/td>\n<\/tr>\n<tr>\n<td>Q2<\/td>\n<td>Huawei<\/td>\n<td>6.17<\/td>\n<\/tr>\n<tr>\n<td>Q2<\/td>\n<td>Oppo<\/td>\n<td>5.5<\/td>\n<\/tr>\n<tr>\n<td>Q2<\/td>\n<td>Vivo<\/td>\n<td>4.21<\/td>\n<\/tr>\n<tr>\n<td>Q3<\/td>\n<td>Samsung<\/td>\n<td>28.45<\/td>\n<\/tr>\n<tr>\n<td>Q3<\/td>\n<td>Apple<\/td>\n<td>27.71<\/td>\n<\/tr>\n<tr>\n<td>Q3<\/td>\n<td>Xiaomi<\/td>\n<td>12.9<\/td>\n<\/tr>\n<tr>\n<td>Q3<\/td>\n<td>Huawei<\/td>\n<td>6<\/td>\n<\/tr>\n<tr>\n<td>Q3<\/td>\n<td>Oppo<\/td>\n<td>5.29<\/td>\n<\/tr>\n<tr>\n<td>Q3<\/td>\n<td>Vivo<\/td>\n<td>4.17<\/td>\n<\/tr>\n<tr>\n<td>Q4<\/td>\n<td>Samsung<\/td>\n<td>27.97<\/td>\n<\/tr>\n<tr>\n<td>Q4<\/td>\n<td>Apple<\/td>\n<td>27.62<\/td>\n<\/tr>\n<tr>\n<td>Q4<\/td>\n<td>Xiaomi<\/td>\n<td>12.68<\/td>\n<\/tr>\n<tr>\n<td>Q4<\/td>\n<td>Huawei<\/td>\n<td>5.17<\/td>\n<\/tr>\n<tr>\n<td>Q4<\/td>\n<td>Oppo<\/td>\n<td>6.07<\/td>\n<\/tr>\n<tr>\n<td>Q4<\/td>\n<td>Vivo<\/td>\n<td>4.66<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>Paste the data table above into the \u201c<a href=\"https:\/\/chartexpo.com\/blog\/power-bi-vs-power-query\" target=\"_blank\" rel=\"noopener\">Power Query<\/a>\u201d window and name it \u201cMarket Share Analysis.\u201d After that, select the \u201cCreate a dataset only\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-create-a-dataset-only-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-create-a-dataset-only-after-doing-datediff-in-power-bi.jpg\" alt=\"Select Create a Dataset Only After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Navigate to the left-side menu, and click on the &#8220;Date Hub&#8221; option. Power BI will populate the data set list. If no data set has been created, you&#8217;ll get an error message.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-data-hub-option-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-data-hub-option-after-doing-datediff-in-power-bi.jpg\" alt=\"Click Data Hub Option After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You can click on \u201cCreate report.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-create-report-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-create-report-after-doing-datediff-in-power-bi.jpg\" alt=\"Click Create Report After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on Market Share Analysis.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-market-share-analysis-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-market-share-analysis-after-doing-datediff-in-power-bi.jpg\" alt=\"Click on Market Share Analysis After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on \u201cExpand All.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-expand-all-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-expand-all-after-doing-datediff-in-power-bi.jpg\" alt=\"Click on Expand All After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on \u201cExpand All\u201d to see the chart metrics.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/see-chart-metrics-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/see-chart-metrics-after-doing-datediff-in-power-bi.jpg\" alt=\"See Chart Metrics After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on \u201cGet more visuals.\u201d<\/li>\n<li>Search ChartExpo and select the Comparison Bar Chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-get-more-visuals-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-get-more-visuals-after-doing-datediff-in-power-bi.jpg\" alt=\"Click on Get More Visuals After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on \u201cAdd.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-add-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-add-after-doing-datediff-in-power-bi.jpg\" alt=\"Click on Add After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You&#8217;ll see the Comparison Bar Chart in the visuals list.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/see-comparison-bar-chart-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/see-comparison-bar-chart-after-doing-datediff-in-power-bi.jpg\" alt=\"See Comparison Bar Chart After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>There\u2019s the option to expand the chart space.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/option-to-expand-chart-space-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/option-to-expand-chart-space-after-doing-datediff-in-power-bi.jpg\" alt=\"Option to Expand Chart Space After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>After that, you\u2019ll have to select the metrics of the data.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-metrics-of-data-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/select-metrics-of-data-after-doing-datediff-in-power-bi.jpg\" alt=\"Select Metrics of Data After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on the second icon of Format Visuals, and click on Visual.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-visual-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/click-on-visual-after-doing-datediff-in-power-bi.jpg\" alt=\"Click on VIsual After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>In Visual, click on License Settings and add the key. After adding the key, you\u2019ll see the comparison bar chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-license-key-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-license-key-after-doing-datediff-in-power-bi.jpg\" alt=\"Add License Key After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To add the header text, click on the General tab. Add the header text in the Title.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-header-text-after-doing-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/add-header-text-after-doing-datediff-in-power-bi.jpg\" alt=\"Add Header Text After Doing Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Here\u2019s the final look at the Comparison Bar Chart in Power BI.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/final-datediff-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/final-datediff-in-power-bi.jpg\" alt=\"Final Datediff in Power BI\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MjkrQ29tcGFyaXNvbis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTcyOSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTcyOSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h4>Insights<\/h4>\n<ul>\n<li>Samsung and Apple consistently hold the highest market shares throughout the quarters.<\/li>\n<li>Xiaomi has shown a consistent market share over the quarters, but it remains behind Apple and Samsung.<\/li>\n<li>Huawei&#8217;s market share is consistent in the first three quarters but it decreases in quarter 4.<\/li>\n<li>Vivo and Oppo have maintained relatively stable shares, with some fluctuations, but there has been no significant growth compared to Apple, Samsung, and Xiaomi.<\/li>\n<\/ul>\n<h3>Using DATEDIFF in Power BI for Advanced Chart Calculations:<\/h3>\n<ol>\n<li>Open your Power BI Desktop or Web.<\/li>\n<li>From the Power BI Visualizations pane, expand three dots at the bottom and select \u201cGet more visuals\u201d.<\/li>\n<li>Search for \u201c<a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MjkrQ29tcGFyaXNvbis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Comparison Bar Chart by ChartExpo<\/a>\u201d on the AppSource.<\/li>\n<li>Add the custom visual.<\/li>\n<li>Select your data and configure the chart settings to create the chart.<\/li>\n<li>Customize your chart properties to add header, axis, legends, and other required information.<\/li>\n<li>Share the chart with your audience.<\/li>\n<\/ol>\n<p>The following video will help you create a <a href=\"https:\/\/chartexpo.com\/blog\/types-of-comparison-charts\" target=\"_blank\" rel=\"noopener\">Comparison Bar Chart<\/a> in Microsoft Power BI.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/JsmPbY-Tn34?si=CW72XFFWnswrwScD\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MjkrQ29tcGFyaXNvbis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTcyOSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTcyOSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h2>FAQs<\/h2>\n<h3>How does the Datediff function work?<\/h3>\n<p>The DATEDIFF function in Power BI calculates the difference between two dates in a specified time unit, thereby offering insights into temporal intervals for reporting and analysis purposes.<\/p>\n<h3>What is the usage of Datediff in DAX?<\/h3>\n<p>DATEDIFF in DAX is used to calculate the time difference between two dates. That gives room for dynamic time-based calculations and analysis in Power BI and other tools.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>DATEDIFF in Power BI plays a vital role in time-based analysis, and that enables the user to understand and calculate date differences, filter by date ranges, aggregate data over time, and make informed decisions.<\/p>\n<p>Visualizing DATEDIFF in Power BI helps the user understand time trends, identify patterns, compare intervals, and effectively communicate insights. Visualization boosts data interpretation and aids in decision-making and anomaly detection.<\/p>\n<p>To get the most out of your DATEDIFF in Power BI, you have to document your calculations and check for leap years. Always document the logic and purpose behind your DATEDIFF calculations. The documentation comes in handy for others who will work on the same report. It can also be used for future references.<\/p>\n<p>If the calculations involve years, always consider leap years, and how they may affect the results. You should consider whether to include the extra day in the leap years.<\/p>\n<p>Now you know what the DATEDIFF in Power BI is, how will you incorporate it into your data analysis?<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Discover how to use DATEDIFF in Power BI for precise time-based analysis. Learn to calculate date differences, enhance visualizations, &#038; gain valuable insights.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/datediff-in-power-bi\"><\/a><\/p>","protected":false},"author":1,"featured_media":46353,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1017],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Datediff in Power BI Visualizing Time Data Easily -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/datediff-in-power-bi\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Datediff in Power BI Visualizing Time Data Easily -\" \/>\r\n<meta name=\"twitter:description\" content=\"Discover how to use DATEDIFF in Power BI for precise time-based analysis. Learn to calculate date differences, enhance visualizations, &amp; gain valuable insights.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/feature-ce729-200x200-1.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Datediff in Power BI Visualizing Time Data Easily -","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:\/\/chartexpo.com\/blog\/datediff-in-power-bi","twitter_card":"summary_large_image","twitter_title":"Datediff in Power BI Visualizing Time Data Easily -","twitter_description":"Discover how to use DATEDIFF in Power BI for precise time-based analysis. Learn to calculate date differences, enhance visualizations, & gain valuable insights.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/01\/feature-ce729-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/datediff-in-power-bi","url":"https:\/\/chartexpo.com\/blog\/datediff-in-power-bi","name":"Datediff in Power BI Visualizing Time Data Easily -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-01-21T16:26:46+00:00","dateModified":"2026-01-29T12:25:02+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/datediff-in-power-bi#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/datediff-in-power-bi"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/datediff-in-power-bi#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Datediff in Power BI Visualizing Time Data Easily"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/46327"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=46327"}],"version-history":[{"count":7,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/46327\/revisions"}],"predecessor-version":[{"id":58428,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/46327\/revisions\/58428"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/46353"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=46327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=46327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=46327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}