{"id":952,"date":"2025-06-23T15:41:37","date_gmt":"2025-06-23T13:41:37","guid":{"rendered":"https:\/\/www.syntera.ch\/blog\/?p=952"},"modified":"2025-06-23T15:41:38","modified_gmt":"2025-06-23T13:41:38","slug":"handling-multiple-dates-in-power-bi","status":"publish","type":"post","link":"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/","title":{"rendered":"Handling multiple Dates in Power BI"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-f56f613f wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><div class=\"wp-block-post-author has-medium-font-size\"><div class=\"wp-block-post-author__avatar\"><img alt='' src='https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=48&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&#038;d=mm&#038;r=g 2x' class='avatar avatar-48 photo' height='48' width='48' \/><\/div><div class=\"wp-block-post-author__content\"><p class=\"wp-block-post-author__byline\">LEAD BUSINESS INTELLIGENCE<\/p><p class=\"wp-block-post-author__name\">Dimitri B\u00fctikofer<\/p><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-vertically-aligned-top is-layout-flow wp-block-column-is-layout-flow\">\n<ul class=\"wp-block-outermost-social-sharing alignright has-small-icon-size has-icon-color is-style-logos-only is-content-justification-left is-layout-flex wp-container-outermost-social-sharing-is-layout-fa5e4718 wp-block-outermost-social-sharing-is-layout-flex\"><li style=\"color: #1a4548\" class=\"outermost-social-sharing-link outermost-social-sharing-link-linkedin has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2025%2F06%2F23%2Fhandling-multiple-dates-in-power-bi%2F&#038;title=Handling%20multiple%20Dates%20in%20Power%20BI\" aria-label=\"Share on LinkedIn\" rel=\"noopener nofollow\" target=\"_blank\" class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M19.7,3H4.3C3.582,3,3,3.582,3,4.3v15.4C3,20.418,3.582,21,4.3,21h15.4c0.718,0,1.3-0.582,1.3-1.3V4.3 C21,3.582,20.418,3,19.7,3z M8.339,18.338H5.667v-8.59h2.672V18.338z M7.004,8.574c-0.857,0-1.549-0.694-1.549-1.548 c0-0.855,0.691-1.548,1.549-1.548c0.854,0,1.547,0.694,1.547,1.548C8.551,7.881,7.858,8.574,7.004,8.574z M18.339,18.338h-2.669 v-4.177c0-0.996-0.017-2.278-1.387-2.278c-1.389,0-1.601,1.086-1.601,2.206v4.249h-2.667v-8.59h2.559v1.174h0.037 c0.356-0.675,1.227-1.387,2.526-1.387c2.703,0,3.203,1.779,3.203,4.092V18.338z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tShare on LinkedIn\t\t<\/span>\n\t<\/a>\n<\/li>\n\n\n<li style=\"color: #1a4548\" class=\"outermost-social-sharing-link outermost-social-sharing-link-mail has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"mailto:?subject=Handling%20multiple%20Dates%20in%20Power%20BI&#038;body=Handling%20multiple%20Dates%20in%20Power%20BI%20&mdash;%20https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2025%2F06%2F23%2Fhandling-multiple-dates-in-power-bi%2F\" aria-label=\"Email this Page\"  class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M20,4H4C2.895,4,2,4.895,2,6v12c0,1.105,0.895,2,2,2h16c1.105,0,2-0.895,2-2V6C22,4.895,21.105,4,20,4z M20,8.236l-8,4.882 L4,8.236V6h16V8.236z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tEmail this Page\t\t<\/span>\n\t<\/a>\n<\/li>\n\n\n<li style=\"color: #1a4548\" class=\"outermost-social-sharing-link outermost-social-sharing-link-whatsapp has-primary-color wp-block-outermost-social-sharing-link\">\n\t<a href=\"https:\/\/api.whatsapp.com\/send?text=Handling%20multiple%20Dates%20in%20Power%20BI%20&mdash;%20https%3A%2F%2Fwww.syntera.ch%2Fblog%2F2025%2F06%2F23%2Fhandling-multiple-dates-in-power-bi%2F\" aria-label=\"Share on WhatsApp\" rel=\"noopener nofollow\" target=\"_blank\" class=\"wp-block-outermost-social-sharing-link-anchor\">\n\t\t<svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M 12.011719 2 C 6.5057187 2 2.0234844 6.478375 2.0214844 11.984375 C 2.0204844 13.744375 2.4814687 15.462563 3.3554688 16.976562 L 2 22 L 7.2324219 20.763672 C 8.6914219 21.559672 10.333859 21.977516 12.005859 21.978516 L 12.009766 21.978516 C 17.514766 21.978516 21.995047 17.499141 21.998047 11.994141 C 22.000047 9.3251406 20.962172 6.8157344 19.076172 4.9277344 C 17.190172 3.0407344 14.683719 2.001 12.011719 2 z M 12.009766 4 C 14.145766 4.001 16.153109 4.8337969 17.662109 6.3417969 C 19.171109 7.8517969 20.000047 9.8581875 19.998047 11.992188 C 19.996047 16.396187 16.413812 19.978516 12.007812 19.978516 C 10.674812 19.977516 9.3544062 19.642812 8.1914062 19.007812 L 7.5175781 18.640625 L 6.7734375 18.816406 L 4.8046875 19.28125 L 5.2851562 17.496094 L 5.5019531 16.695312 L 5.0878906 15.976562 C 4.3898906 14.768562 4.0204844 13.387375 4.0214844 11.984375 C 4.0234844 7.582375 7.6067656 4 12.009766 4 z M 8.4765625 7.375 C 8.3095625 7.375 8.0395469 7.4375 7.8105469 7.6875 C 7.5815469 7.9365 6.9355469 8.5395781 6.9355469 9.7675781 C 6.9355469 10.995578 7.8300781 12.182609 7.9550781 12.349609 C 8.0790781 12.515609 9.68175 15.115234 12.21875 16.115234 C 14.32675 16.946234 14.754891 16.782234 15.212891 16.740234 C 15.670891 16.699234 16.690438 16.137687 16.898438 15.554688 C 17.106437 14.971687 17.106922 14.470187 17.044922 14.367188 C 16.982922 14.263188 16.816406 14.201172 16.566406 14.076172 C 16.317406 13.951172 15.090328 13.348625 14.861328 13.265625 C 14.632328 13.182625 14.464828 13.140625 14.298828 13.390625 C 14.132828 13.640625 13.655766 14.201187 13.509766 14.367188 C 13.363766 14.534188 13.21875 14.556641 12.96875 14.431641 C 12.71875 14.305641 11.914938 14.041406 10.960938 13.191406 C 10.218937 12.530406 9.7182656 11.714844 9.5722656 11.464844 C 9.4272656 11.215844 9.5585938 11.079078 9.6835938 10.955078 C 9.7955938 10.843078 9.9316406 10.663578 10.056641 10.517578 C 10.180641 10.371578 10.223641 10.267562 10.306641 10.101562 C 10.389641 9.9355625 10.347156 9.7890625 10.285156 9.6640625 C 10.223156 9.5390625 9.737625 8.3065 9.515625 7.8125 C 9.328625 7.3975 9.131125 7.3878594 8.953125 7.3808594 C 8.808125 7.3748594 8.6425625 7.375 8.4765625 7.375 z\"><\/path><\/svg>\t\t<span class=\"wp-block-outermost-social-sharing-link-label screen-reader-text\">\n\t\t\tShare on WhatsApp\t\t<\/span>\n\t<\/a>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Handling multiple relevant date fields in Power BI is a challenge I encounter in almost every project. Whether you\u2019re working with invoices, sales, or project data, it\u2019s common to have more than one meaningful date on a single fact table. For instance, invoice data typically includes both an invoice date and a due date, sales data often has an order date and a shipping date and project data may track a start date and a projected end date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Since time is a crucial analytical dimension, we almost always want to visualize our KPIs over time or enable users to filter the data using a date-based slicer. For example, in financial dashboards, you might track invoiced amounts by month but you may also want to understand when those amounts are expected to be received based on due dates. Similarly, while sales teams are mostly interested in the date an order is placed, the logistics departments care more about the shipment date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Following Power\u202fBI best practices, we build star schemas with a separate, marked Date table. But Power\u202fBI only allows one active relationship between two tables, so how do we handle multiple relevant date fields like invoice date, due date, or shipment date in the same table? There are two different solutions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Using inactive relationship + USERELATIONSHIP()<\/li>\n\n\n\n<li>Handling all logic in a measure (to reduce inactive relationships)<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Example Scenario<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">In our example, we have an invoice table with product, customer, quantity, amount, invoice date, and due date. Using the default (active) relationship to the Date table via invoice date, we can already track invoice amount per month but now we also want to track the due amount.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1476\" height=\"821\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/01_scenario_visual.png\" alt=\"\" class=\"wp-image-955\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/01_scenario_visual.png 1476w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/01_scenario_visual-300x167.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/01_scenario_visual-1024x570.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/01_scenario_visual-768x427.png 768w\" sizes=\"auto, (max-width: 1476px) 100vw, 1476px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The model currently includes a dedicated Date table linked to the invoice table via invoice_date.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1140\" height=\"583\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/02_scenario_datamodel.png\" alt=\"\" class=\"wp-image-956\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/02_scenario_datamodel.png 1140w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/02_scenario_datamodel-300x153.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/02_scenario_datamodel-1024x524.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/02_scenario_datamodel-768x393.png 768w\" sizes=\"auto, (max-width: 1140px) 100vw, 1140px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Inactive relationship + USERELATIONSHIP()<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Power\u202fBI only allows one active relationship between your Date table and a fact table. But you can create as many inactive relationships as needed. In our example, we add an inactive relationship between the Date table and the due_date column of the invoice table. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1033\" height=\"505\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image.png\" alt=\"\" class=\"wp-image-958\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image.png 1033w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-300x147.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-1024x501.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-768x375.png 768w\" sizes=\"auto, (max-width: 1033px) 100vw, 1033px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">By default, the active relationship (invoice_date) is used. To calculate metrics based on other dates, you can explicitly activate those inactive relationships for a specific calculation inside your DAX measures using USERELATIONSHIP():<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SUM amount due = \nCALCULATE(\n    &#91;SUM amount],\n    USERELATIONSHIP('Date'&#91;Date], invoices&#91;due_date])\n)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This tells Power\u202fBI to use the due_date \u2192 Date relationship just for this calculation, without altering the default model behavior. That means we can now show both the amount by invoice date as well as the amount by due date in the same visual, and still use our Date table as slicer or dimension.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1470\" height=\"639\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-1.png\" alt=\"\" class=\"wp-image-959\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-1.png 1470w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-1-300x130.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-1-1024x445.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-1-768x334.png 768w\" sizes=\"auto, (max-width: 1470px) 100vw, 1470px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Without using inactive relationships<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Although using inactive relationships is usually the easier and cleaner way, there are cases (especially in large models), where it&#8217;s better to avoid them. When you have a fact table with many different date columns, adding a relationship for each one can quickly become unmanageable.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Instead, you can solve this using DAX only, without creating any relationship at all. It\u2019s a bit more work, but it gives you full control and keeps the data model cleaner.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The idea is to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Capture the selected date range from the Date table using MIN() and MAX()<\/li>\n\n\n\n<li>Remove any filters on the Date table<\/li>\n\n\n\n<li>Apply the filter directly to the due date field in the fact table<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SUM amount due no relation = \nVAR _MinDate = MIN('Date'&#91;Date])\nVAR _MaxDate = MAX('Date'&#91;Date])\n\nRETURN\nCALCULATE(\n    &#91;SUM amount],\n    REMOVEFILTERS('Date'),\n    DATESBETWEEN(\n        invoices&#91;due_date],\n        _MinDate,\n        _MaxDate\n    )\n)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This measure will respect the selection made on the Date table but instead of relying on a relationship, it applies the filter directly to the due_date column. The result is exactly the same, as can see in the visual below (lightblue: using inactive relationship, green: without using inactive relationship)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"442\" src=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-2-1024x442.png\" alt=\"\" class=\"wp-image-960\" srcset=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-2-1024x442.png 1024w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-2-300x129.png 300w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-2-768x331.png 768w, https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image-2.png 1476w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Read More about Power BI:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.syntera.ch\/blog\/2024\/01\/16\/analyse-bexio-data-with-power-bi\/\">Analyse bexio Data with Power BI<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.syntera.ch\/blog\/2023\/03\/21\/static-and-dynamic-row-level-security-in-power-bi\/\">Static and dynamic Row-level-Security in Power BI<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.syntera.ch\/blog\/2024\/08\/27\/building-gantt-charts-with-power-bi\/\">Building Gantt Charts with Power BI &#8211; Syntera<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.syntera.ch\/blog\/2024\/03\/19\/automated-power-bi-testing-with-selenium\/\">Automated Power BI Testing with Selenium<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.syntera.ch\/blog\/2024\/11\/20\/power-bi-shape-maps-custom-switzerland-map\/\">Power BI Shape Maps: Custom Switzerland Map &#8211; Syntera<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Handling multiple relevant date fields in Power BI is a challenge I encounter in almost every project. Whether you\u2019re working with invoices, sales, or project data, it\u2019s common to have more than one meaningful date on a single fact table. For instance, invoice data typically includes both an invoice date and a due date, sales [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":958,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[6],"class_list":["post-952","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","tag-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Handling multiple Dates in Power BI - Syntera<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Handling multiple Dates in Power BI - Syntera\" \/>\n<meta property=\"og:description\" content=\"Handling multiple relevant date fields in Power BI is a challenge I encounter in almost every project. Whether you\u2019re working with invoices, sales, or project data, it\u2019s common to have more than one meaningful date on a single fact table. For instance, invoice data typically includes both an invoice date and a due date, sales [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Syntera\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-23T13:41:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-23T13:41:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1033\" \/>\n\t<meta property=\"og:image:height\" content=\"505\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dimitri B\u00fctikofer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dimitri B\u00fctikofer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/\",\"url\":\"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/\",\"name\":\"Handling multiple Dates in Power BI - Syntera\",\"isPartOf\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/#website\"},\"datePublished\":\"2025-06-23T13:41:37+00:00\",\"dateModified\":\"2025-06-23T13:41:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/843f812ce16de687e4d4527aee313034\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.syntera.ch\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Handling multiple Dates in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#website\",\"url\":\"https:\/\/www.syntera.ch\/blog\/\",\"name\":\"Syntera\",\"description\":\"translating data into business value.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.syntera.ch\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/843f812ce16de687e4d4527aee313034\",\"name\":\"Dimitri B\u00fctikofer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&d=mm&r=g\",\"caption\":\"Dimitri B\u00fctikofer\"},\"sameAs\":[\"http:\/\/www.syntera.ch\"],\"url\":\"https:\/\/www.syntera.ch\/blog\/author\/dimitri\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Handling multiple Dates in Power BI - Syntera","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:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Handling multiple Dates in Power BI - Syntera","og_description":"Handling multiple relevant date fields in Power BI is a challenge I encounter in almost every project. Whether you\u2019re working with invoices, sales, or project data, it\u2019s common to have more than one meaningful date on a single fact table. For instance, invoice data typically includes both an invoice date and a due date, sales [&hellip;]","og_url":"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/","og_site_name":"Syntera","article_published_time":"2025-06-23T13:41:37+00:00","article_modified_time":"2025-06-23T13:41:38+00:00","og_image":[{"width":1033,"height":505,"url":"https:\/\/www.syntera.ch\/blog\/wp-content\/uploads\/2025\/06\/image.png","type":"image\/png"}],"author":"Dimitri B\u00fctikofer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dimitri B\u00fctikofer","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/","url":"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/","name":"Handling multiple Dates in Power BI - Syntera","isPartOf":{"@id":"https:\/\/www.syntera.ch\/blog\/#website"},"datePublished":"2025-06-23T13:41:37+00:00","dateModified":"2025-06-23T13:41:38+00:00","author":{"@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/843f812ce16de687e4d4527aee313034"},"breadcrumb":{"@id":"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.syntera.ch\/blog\/2025\/06\/23\/handling-multiple-dates-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.syntera.ch\/blog\/"},{"@type":"ListItem","position":2,"name":"Handling multiple Dates in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/www.syntera.ch\/blog\/#website","url":"https:\/\/www.syntera.ch\/blog\/","name":"Syntera","description":"translating data into business value.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.syntera.ch\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/843f812ce16de687e4d4527aee313034","name":"Dimitri B\u00fctikofer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.syntera.ch\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9cbefca9184e6b8146d83f72900473b791b31bc6c2a10a8e57f77e9c41f11b45?s=96&d=mm&r=g","caption":"Dimitri B\u00fctikofer"},"sameAs":["http:\/\/www.syntera.ch"],"url":"https:\/\/www.syntera.ch\/blog\/author\/dimitri\/"}]}},"_links":{"self":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/comments?post=952"}],"version-history":[{"count":6,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/952\/revisions"}],"predecessor-version":[{"id":964,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/posts\/952\/revisions\/964"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/media\/958"}],"wp:attachment":[{"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/media?parent=952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/categories?post=952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.syntera.ch\/blog\/wp-json\/wp\/v2\/tags?post=952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}