{"id":9523,"date":"2021-03-23T18:11:00","date_gmt":"2021-03-23T18:11:00","guid":{"rendered":"https:\/\/minova.nl\/?p=9523"},"modified":"2023-05-05T11:42:06","modified_gmt":"2023-05-05T11:42:06","slug":"optimize-dax","status":"publish","type":"post","link":"https:\/\/minova.nl\/en\/dax-optimaliseren\/","title":{"rendered":"DAX Optimization"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"9523\" class=\"elementor elementor-9523\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-519dd79 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"519dd79\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5760595\" data-id=\"5760595\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6b41ccd elementor-widget elementor-widget-heading\" data-id=\"6b41ccd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">A Power BI report can sometimes become slow. Very annoying for its users. Often this is due to slow DAX. How can you do something about that? Here is the video in which I explain this during a presentation to the Dutch PBI Users Group. <\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-302cec7 elementor-widget elementor-widget-video\" data-id=\"302cec7\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=Ax3muBOSNwo&amp;t=5s&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>A Power BI report can sometimes become slow. Very annoying for its users. Often this is due to slow DAX. How can you do something about that? Here is the video in which I explain this during a presentation to the Dutch PBI Users Group. <\/p>","protected":false},"author":2,"featured_media":10277,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[],"class_list":["post-9523","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi-dax"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DAX Optimaliseren - Minova<\/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:\/\/minova.nl\/en\/optimize-dax\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DAX Optimaliseren - Minova\" \/>\n<meta property=\"og:description\" content=\"Een Power BI rapport kan soms traag worden. Erg vervelend voor de gebruikers ervan. Vaak komt dat door trage DAX. Hoe kun je daar wat aan doen? Hierbij de video waarin ik dat uitleg tijdens een presentatie aan de Nederlandse PBI Gebruikersgroep.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/minova.nl\/en\/optimize-dax\/\" \/>\n<meta property=\"og:site_name\" content=\"Minova\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-23T18:11:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-05T11:42:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/03\/Thumbnail-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"331\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Marnix Jansen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marnix Jansen\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/\"},\"author\":{\"name\":\"Marnix Jansen\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"headline\":\"DAX Optimaliseren\",\"datePublished\":\"2021-03-23T18:11:00+00:00\",\"dateModified\":\"2023-05-05T11:42:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/\"},\"wordCount\":55,\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/Thumbnail-1.jpg\",\"articleSection\":[\"Power BI DAX\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/\",\"url\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/\",\"name\":\"DAX Optimaliseren - Minova\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/Thumbnail-1.jpg\",\"datePublished\":\"2021-03-23T18:11:00+00:00\",\"dateModified\":\"2023-05-05T11:42:06+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/#primaryimage\",\"url\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/Thumbnail-1.jpg\",\"contentUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/Thumbnail-1.jpg\",\"width\":640,\"height\":331},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/minova.nl\\\/dax-optimaliseren\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/minova.nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DAX Optimaliseren\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#website\",\"url\":\"https:\\\/\\\/minova.nl\\\/\",\"name\":\"Minova\",\"description\":\"Van data naar inzicht\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/minova.nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\",\"name\":\"Marnix Jansen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"caption\":\"Marnix Jansen\"},\"sameAs\":[\"https:\\\/\\\/minova.nl\"],\"url\":\"https:\\\/\\\/minova.nl\\\/en\\\/author\\\/marnix\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DAX Optimization - Minova","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:\/\/minova.nl\/en\/optimize-dax\/","og_locale":"en_US","og_type":"article","og_title":"DAX Optimaliseren - Minova","og_description":"Een Power BI rapport kan soms traag worden. Erg vervelend voor de gebruikers ervan. Vaak komt dat door trage DAX. Hoe kun je daar wat aan doen? Hierbij de video waarin ik dat uitleg tijdens een presentatie aan de Nederlandse PBI Gebruikersgroep.","og_url":"https:\/\/minova.nl\/en\/optimize-dax\/","og_site_name":"Minova","article_published_time":"2021-03-23T18:11:00+00:00","article_modified_time":"2023-05-05T11:42:06+00:00","og_image":[{"width":640,"height":331,"url":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/03\/Thumbnail-1.jpg","type":"image\/jpeg"}],"author":"Marnix Jansen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marnix Jansen"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/minova.nl\/dax-optimaliseren\/#article","isPartOf":{"@id":"https:\/\/minova.nl\/dax-optimaliseren\/"},"author":{"name":"Marnix Jansen","@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"headline":"DAX Optimaliseren","datePublished":"2021-03-23T18:11:00+00:00","dateModified":"2023-05-05T11:42:06+00:00","mainEntityOfPage":{"@id":"https:\/\/minova.nl\/dax-optimaliseren\/"},"wordCount":55,"image":{"@id":"https:\/\/minova.nl\/dax-optimaliseren\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/03\/Thumbnail-1.jpg","articleSection":["Power BI DAX"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/minova.nl\/dax-optimaliseren\/","url":"https:\/\/minova.nl\/dax-optimaliseren\/","name":"DAX Optimization - Minova","isPartOf":{"@id":"https:\/\/minova.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/minova.nl\/dax-optimaliseren\/#primaryimage"},"image":{"@id":"https:\/\/minova.nl\/dax-optimaliseren\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/03\/Thumbnail-1.jpg","datePublished":"2021-03-23T18:11:00+00:00","dateModified":"2023-05-05T11:42:06+00:00","author":{"@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"breadcrumb":{"@id":"https:\/\/minova.nl\/dax-optimaliseren\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/minova.nl\/dax-optimaliseren\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minova.nl\/dax-optimaliseren\/#primaryimage","url":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/03\/Thumbnail-1.jpg","contentUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/03\/Thumbnail-1.jpg","width":640,"height":331},{"@type":"BreadcrumbList","@id":"https:\/\/minova.nl\/dax-optimaliseren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minova.nl\/"},{"@type":"ListItem","position":2,"name":"DAX Optimaliseren"}]},{"@type":"WebSite","@id":"https:\/\/minova.nl\/#website","url":"https:\/\/minova.nl\/","name":"Minova","description":"From data to insight","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minova.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e","name":"Marnix Jansen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","caption":"Marnix Jansen"},"sameAs":["https:\/\/minova.nl"],"url":"https:\/\/minova.nl\/en\/author\/marnix\/"}]}},"_links":{"self":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/9523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/comments?post=9523"}],"version-history":[{"count":1,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/9523\/revisions"}],"predecessor-version":[{"id":10143,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/9523\/revisions\/10143"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media\/10277"}],"wp:attachment":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media?parent=9523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/categories?post=9523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/tags?post=9523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}