{"id":9440,"date":"2020-07-10T14:07:00","date_gmt":"2020-07-10T14:07:00","guid":{"rendered":"https:\/\/minova.nl\/?p=9440"},"modified":"2023-05-05T11:42:08","modified_gmt":"2023-05-05T11:42:08","slug":"power-bi-dax-dateadd-versus-previousmonth","status":"publish","type":"post","link":"https:\/\/minova.nl\/en\/power-bi-dax-dateadd-versus-previousmonth\/","title":{"rendered":"Power BI DAX: DATEADD vs. PREVIOUSMONTH"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"9440\" class=\"elementor elementor-9440\">\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\">Omdat ik van mijn klanten vragen krijg over dit onderwerp heb ik besloten er een blog aan te wijden. Wat is het verschil tussen DATEADD en PREVIOUSMONTH? Is het resultaat niet hetzelfde? Het antwoord is dat dit soms zo is, maar zeker niet altijd.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d38bdd elementor-widget elementor-widget-heading\" data-id=\"1d38bdd\" 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\">In dit scenario is het resultaat op maandniveau hetzelfde<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee0ddcb elementor-widget elementor-widget-heading\" data-id=\"ee0ddcb\" 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<h3 class=\"elementor-heading-title elementor-size-default\">Hier is het:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2c6241e elementor-widget elementor-widget-heading\" data-id=\"2c6241e\" 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\"><pre><code>DATEADD =\nCALCULATE (\n[Sales],\nDATEADD ( dim_Calender[Date] , -1 , MONTH )\n)\n\nPREVIOUSMONTH =\nCALCULATE (\n[Sales],\nPREVIOUSMONTH ( dim_Calender[Date] )\n)<\/code><pre><\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-138f3fd elementor-widget elementor-widget-image\" data-id=\"138f3fd\" data-element_type=\"widget\" data-e-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\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"976\" height=\"750\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table1.png\" class=\"attachment-full size-full wp-image-9442 lazyload\" alt=\"\" data-srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table1.png 976w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table1-300x231.png 300w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table1-768x590.png 768w\" sizes=\"(max-width: 976px) 100vw, 976px\" \/><noscript><img decoding=\"async\" width=\"976\" height=\"750\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table1.png\" class=\"attachment-full size-full wp-image-9442 lazyload\" alt=\"\" srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table1.png 976w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table1-300x231.png 300w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table1-768x590.png 768w\" sizes=\"(max-width: 976px) 100vw, 976px\" \/><\/noscript>\t\t\t\t\t\t\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-49d62ac elementor-widget elementor-widget-heading\" data-id=\"49d62ac\" 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\">Dit geeft eenvoudigweg de Verkoop van de maand v\u00f3\u00f3r die in de initi\u00eble filtercontext. Het enige verschil hier is het resultaat op jaar- en totaalniveau. DATEADD geeft de som van de resultaten op maandniveau, terwijl PREVIOUSMONTH de eerste maand van het jaar op jaarniveau geeft en geen resultaat op totaalniveau. Om op jaar- en totaalniveau een resultaat te verkrijgen dat overeenkomt met het door DATEADD verkregen resultaat is een iterator nodig die alle jaren en alle maanden afloopt en vervolgens de resultaten optelt, hetgeen kan worden gedaan met SUMX.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c76141 elementor-widget elementor-widget-heading\" data-id=\"1c76141\" 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<h3 class=\"elementor-heading-title elementor-size-default\">Hier is het:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-efcacaf elementor-widget elementor-widget-heading\" data-id=\"efcacaf\" 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\"><pre><code>PREVIOUSMONTH =\nSUMX (\nVALUES ( dim_Calender[YearMonth] ),\nCALCULATE (\n[Sales],\nPREVIOUSMONTH ( dim_Calender[Date] )\n)\n)<\/code><pre><\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d896574 elementor-widget elementor-widget-heading\" data-id=\"d896574\" 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\">Maar het echte verschil is te zien wanneer we naar het individuele dagniveau kijken.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dbbd7ef elementor-widget elementor-widget-image\" data-id=\"dbbd7ef\" data-element_type=\"widget\" data-e-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\t\t\t<img decoding=\"async\" width=\"1332\" height=\"1310\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2.png\" class=\"attachment-full size-full wp-image-9443 lazyload\" alt=\"\" data-srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2.png 1332w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2-300x295.png 300w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2-1024x1007.png 1024w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2-768x755.png 768w\" sizes=\"(max-width: 1332px) 100vw, 1332px\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"1332\" height=\"1310\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2.png\" class=\"attachment-full size-full wp-image-9443 lazyload\" alt=\"\" srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2.png 1332w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2-300x295.png 300w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2-1024x1007.png 1024w, https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Table2-768x755.png 768w\" sizes=\"(max-width: 1332px) 100vw, 1332px\" \/><\/noscript>\t\t\t\t\t\t\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-b917cf1 elementor-widget elementor-widget-heading\" data-id=\"b917cf1\" 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\">PREVIOUSMONTH, vergelijkbaar met PARALLELPERIOD, geeft het resultaat voor de hele vorige maand, ook al is de individuele dag ingevoerd in de filtercontext. Geen van beide is \"fout\" of \"goed\", het hangt allemaal af van de informatiebehoefte van de gebruiker van het dashboard.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df0220b elementor-widget elementor-widget-heading\" data-id=\"df0220b\" 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\">Laten we nu eens kijken hoe we de verkoop van 2 maanden geleden kunnen verkrijgen. Dit is de aangepaste code voor de twee formules.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-754c7fd elementor-widget elementor-widget-heading\" data-id=\"754c7fd\" 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<h3 class=\"elementor-heading-title elementor-size-default\">Hier is het:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f325fe elementor-widget elementor-widget-heading\" data-id=\"0f325fe\" 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\"><pre><code>DATEADD =\nCALCULATE (\n[Sales],\nDATEADD ( dim_Calender[Date] , -2 , MONTH )\n)\n\nPREVIOUSMONTH =\nCALCULATE (\n[Sales],\nPREVIOUSMONTH ( PREVIOUSMONTH ( dim_Calender[Date] ) )\n)<\/code><pre><\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e5ffbd elementor-widget elementor-widget-heading\" data-id=\"7e5ffbd\" 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<h3 class=\"elementor-heading-title elementor-size-default\">Hier is het:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-453527e elementor-widget elementor-widget-heading\" data-id=\"453527e\" 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\">Hetzelfde gedrag kan worden waargenomen. Deze keer echter moet PREVIOUSMONTH worden vervangen door PARALLELPERIOD. Dat is gemakkelijker te schrijven en te lezen en heeft een snellere prestatie. Hier is de code van de laatste.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-68da714 elementor-widget elementor-widget-heading\" data-id=\"68da714\" 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\"><pre><code>PARALLELPERIOD =\nCALCULATE\n[Sales],\nPARALLELPERIOD ( dim_Calender[Date], -2, MONTH )\n)<\/code><pre><\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-064dbeb elementor-widget elementor-widget-heading\" data-id=\"064dbeb\" 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<h3 class=\"elementor-heading-title elementor-size-default\">Tussen haakjes, hier is de code voor de tabel Verkoop die ik voor dit voorbeeld heb gebruikt.<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ad170a elementor-widget elementor-widget-heading\" data-id=\"2ad170a\" 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\"><pre><code>Sales =\nADDCOLUMNS (\nCALENDER (\nDATE ( 2017, 01, 01, ),\nDATE ( 2020, 07, 10, )\n),\n\"Value\",\nDATEDIFF ( DATE ( 2020, 07, 10 ), [Date], DAY )\n)<\/code><pre><\/p>\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>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Omdat ik van mijn klanten vragen krijg over dit onderwerp heb ik besloten er een blog aan te wijden. Wat is het verschil tussen DATEADD en PREVIOUSMONTH? Is het resultaat niet hetzelfde? Het antwoord is dat dit soms zo is, maar zeker niet altijd. In dit scenario is het resultaat op maandniveau hetzelfde Hier is [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":10270,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[],"class_list":["post-9440","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>Power BI DAX: DATEADD versus PREVIOUSMONTH - 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\/power-bi-dax-dateadd-versus-previousmonth\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI DAX: DATEADD versus PREVIOUSMONTH - Minova\" \/>\n<meta property=\"og:description\" content=\"Omdat ik van mijn klanten vragen krijg over dit onderwerp heb ik besloten er een blog aan te wijden. Wat is het verschil tussen DATEADD en PREVIOUSMONTH? Is het resultaat niet hetzelfde? Het antwoord is dat dit soms zo is, maar zeker niet altijd. In dit scenario is het resultaat op maandniveau hetzelfde Hier is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/minova.nl\/en\/power-bi-dax-dateadd-versus-previousmonth\/\" \/>\n<meta property=\"og:site_name\" content=\"Minova\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-10T14:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-05T11:42:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Thumbnail-dateadd.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1480\" \/>\n\t<meta property=\"og:image:height\" content=\"481\" \/>\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\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/\"},\"author\":{\"name\":\"Marnix Jansen\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"headline\":\"Power BI DAX: DATEADD versus PREVIOUSMONTH\",\"datePublished\":\"2020-07-10T14:07:00+00:00\",\"dateModified\":\"2023-05-05T11:42:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/\"},\"wordCount\":292,\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/Thumbnail-dateadd.jpg\",\"articleSection\":[\"Power BI DAX\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/\",\"url\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/\",\"name\":\"Power BI DAX: DATEADD versus PREVIOUSMONTH - Minova\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/Thumbnail-dateadd.jpg\",\"datePublished\":\"2020-07-10T14:07:00+00:00\",\"dateModified\":\"2023-05-05T11:42:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/#primaryimage\",\"url\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/Thumbnail-dateadd.jpg\",\"contentUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/Thumbnail-dateadd.jpg\",\"width\":1480,\"height\":481},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/minova.nl\\\/power-bi-dax-dateadd-versus-previousmonth\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/minova.nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI DAX: DATEADD versus PREVIOUSMONTH\"}]},{\"@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":"Power BI DAX: DATEADD versus PREVIOUSMONTH - 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\/power-bi-dax-dateadd-versus-previousmonth\/","og_locale":"en_US","og_type":"article","og_title":"Power BI DAX: DATEADD versus PREVIOUSMONTH - Minova","og_description":"Omdat ik van mijn klanten vragen krijg over dit onderwerp heb ik besloten er een blog aan te wijden. Wat is het verschil tussen DATEADD en PREVIOUSMONTH? Is het resultaat niet hetzelfde? Het antwoord is dat dit soms zo is, maar zeker niet altijd. In dit scenario is het resultaat op maandniveau hetzelfde Hier is [&hellip;]","og_url":"https:\/\/minova.nl\/en\/power-bi-dax-dateadd-versus-previousmonth\/","og_site_name":"Minova","article_published_time":"2020-07-10T14:07:00+00:00","article_modified_time":"2023-05-05T11:42:08+00:00","og_image":[{"width":1480,"height":481,"url":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Thumbnail-dateadd.jpg","type":"image\/jpeg"}],"author":"Marnix Jansen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marnix Jansen","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/#article","isPartOf":{"@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/"},"author":{"name":"Marnix Jansen","@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"headline":"Power BI DAX: DATEADD versus PREVIOUSMONTH","datePublished":"2020-07-10T14:07:00+00:00","dateModified":"2023-05-05T11:42:08+00:00","mainEntityOfPage":{"@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/"},"wordCount":292,"image":{"@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Thumbnail-dateadd.jpg","articleSection":["Power BI DAX"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/","url":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/","name":"Power BI DAX: DATEADD versus PREVIOUSMONTH - Minova","isPartOf":{"@id":"https:\/\/minova.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/#primaryimage"},"image":{"@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Thumbnail-dateadd.jpg","datePublished":"2020-07-10T14:07:00+00:00","dateModified":"2023-05-05T11:42:08+00:00","author":{"@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"breadcrumb":{"@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/#primaryimage","url":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Thumbnail-dateadd.jpg","contentUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/07\/Thumbnail-dateadd.jpg","width":1480,"height":481},{"@type":"BreadcrumbList","@id":"https:\/\/minova.nl\/power-bi-dax-dateadd-versus-previousmonth\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minova.nl\/"},{"@type":"ListItem","position":2,"name":"Power BI DAX: DATEADD versus PREVIOUSMONTH"}]},{"@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\/9440","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=9440"}],"version-history":[{"count":5,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/9440\/revisions"}],"predecessor-version":[{"id":11061,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/9440\/revisions\/11061"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media\/10270"}],"wp:attachment":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media?parent=9440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/categories?post=9440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/tags?post=9440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}