{"id":2095,"date":"2022-11-17T06:13:09","date_gmt":"2022-11-17T06:13:09","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=2095"},"modified":"2022-11-17T08:55:40","modified_gmt":"2022-11-17T08:55:40","slug":"valt-een-datum-in-het-weekend-in-power-bi","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/17\/falls-a-date-on-the-weekend-in-power-bi\/","title":{"rendered":"Does a date fall on a weekend in Power BI"},"content":{"rendered":"<p>Sometimes it can be useful to know whether a certain date falls on a weekend or not. You may want to know how often a certain activity takes place on weekends compared to weekdays. In Power BI, it is quite easy to determine the day based on a date. In this article, I&#039;ll show you how to do it easily.<\/p>\n\n\n\n<p>We use a dataset with some dates and activities (in this case sports). Based on the date, we will see how often a sport occurs during the weekend.<\/p>\n\n\n\n<p>At the bottom of this page you can download the example file with source file <a href=\"#downloads\">to download<\/a> so that you can follow everything step by step.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-gegevens-ophalen-uit-een-bron\">Retrieving data from a source<\/h2>\n\n\n\n<p>Start Power BI and create a new report.<br>We retrieve our data from the Excel file Aktivities.xlsx. To do this, go to in the Ribbon <strong>Start<\/strong> and choose <strong>Import data<\/strong>. Choose from the menu <strong>excel workbook<\/strong> and then click the button <strong>Make a connection<\/strong>.<\/p>\n\n\n\n<p>Go to the folder where the Excel file Aktivities.xlsx is stored and select the file. Press the button <strong>To open<\/strong> to import the data.<\/p>\n\n\n\n<p>Check the box <strong>Rows<\/strong> and then click the button <strong>Transform data<\/strong>.<\/p>\n\n\n\n<p>You should have imported the following columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ID;<\/li>\n\n\n\n<li>Date;<\/li>\n\n\n\n<li>Time of day;<\/li>\n\n\n\n<li>Activity.<\/li>\n<\/ul>\n\n\n\n<p>The data types should already be set correctly. The date must in any case be set as the Date data type.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1226\" height=\"1038\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Power-BI-Gegevens-importeren-vanuit-Excel-bestand.gif\" alt=\"Power BI - Import data from excel file\" class=\"wp-image-2440\"\/><figcaption class=\"wp-element-caption\">Power BI \u2013 Import data from excel file<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Determine the day of the week based on the date<\/h2>\n\n\n\n<p>To determine the day of the week we add a column to our dataset.<\/p>\n\n\n\n<p>In the Power Query Editor, go to the tab <strong>Add column<\/strong> and click <strong>Custom column<\/strong>.<\/p>\n\n\n\n<p>A new window will open. Enter the name \u201cCustom\u201d in the text field <strong>New column name<\/strong> to \u201cWeekday\u201d.<\/p>\n\n\n\n<p>Fill in the <strong>Custom column formula<\/strong> enter the following M code:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><a href=\"https:\/\/learn.microsoft.com\/nl-nl\/powerquery-m\/date-dayofweek\" target=\"_blank\" rel=\"noreferrer noopener\">Date.DayOfWeekName([Date],&quot;NL-nl&quot;)<\/a><\/code><\/pre>\n\n\n\n<p>Then click <strong>OK<\/strong>.<\/p>\n\n\n\n<p>An extra column has now been created in which the weekdays are listed that belong to the relevant date.<\/p>\n\n\n\n<p>[image]<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Place data in a visual<\/h2>\n\n\n\n<p>Exit the Power Query Editor by clicking the button <strong>Close and apply<\/strong> to click. We then come to the main Power BI window.<\/p>\n\n\n\n<p>Select from the pane <strong>Visualizations<\/strong> the <strong>Matrix<\/strong>-visual. <\/p>\n\n\n\n<p>Then drag from the pane <strong>Fields<\/strong> the field:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Date<\/strong> nasty <strong>Rows<\/strong><\/li>\n\n\n\n<li><strong>Weekday<\/strong> nasty <strong>Columns<\/strong><\/li>\n\n\n\n<li><strong>Activity<\/strong> nasty <strong>Values<\/strong><\/li>\n<\/ul>\n\n\n\n<p>In the matrix table, the day of the week is displayed per column. It is striking that this is not set in order of the weekdays, but in alphabetical order. So the next step is to put the days of the week in the correct order.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1585\" height=\"813\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Power-BI-Gegevens-in-matrix-visual-plaatsen.gif\" alt=\"Power BI - Place data in visual\" class=\"wp-image-2439\"\/><figcaption class=\"wp-element-caption\">Power BI \u2013 Place data in visual<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Arrange weekdays in order<\/h2>\n\n\n\n<p>To put the weekdays in the correct order, we need to make a helper column with day numbers in the data table.<\/p>\n\n\n\n<p>To determine the day number from a date, we use the function <code>Date.DayOfWeek<\/code>.<\/p>\n\n\n\n<p>Open the Power Query Editor by clicking the button in the main window <strong>Transform data<\/strong>.<\/p>\n\n\n\n<p>In the Power Query editor, go to <strong>Add column<\/strong> and click <strong>Custom column<\/strong>.<\/p>\n\n\n\n<p>Match <strong>New column name<\/strong> <em>Amended<\/em> to to <em>Day number<\/em>.<\/p>\n\n\n\n<p>fill in <strong>Custom column formula<\/strong> the following function:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Date.DayOfWeek([Date], 1)<\/code><\/pre>\n\n\n\n<p>Pass of the column <strong>Day number<\/strong> the data type to <strong>Round number<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1715\" height=\"881\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Power-BI-Hulpkolom-dagnummer-toevoegen.gif\" alt=\"Power BI - Add day number helper column\" class=\"wp-image-2438\"\/><figcaption class=\"wp-element-caption\">Power BI \u2013 Add auxiliary column with day numbers<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Explanation of function Date.DayOfWeek<\/h2>\n\n\n\n<p>The function <code><a href=\"https:\/\/learn.microsoft.com\/nl-nl\/powerquery-m\/date-dayofweek\" target=\"_blank\" rel=\"noreferrer noopener\">Date.DayOfWeek<\/a><\/code> returns a number from 0 to 6 based on an entered date. The function has two arguments:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>dateTime (which data type must be date, datetime or datetimezone);<\/li>\n\n\n\n<li>firstDayOfWeek (whose data type is a numeric number).<\/li>\n<\/ul>\n\n\n\n<p>Power BI sees Sunday as the first day of the week (day 0) and Saturday as the last day of the week (day 6). In the Netherlands, Monday (day 1) is the first day of the week. On to the argument <code>firstdayOfWeek<\/code> Entering the number 1 indicates that Monday is the first day of the week.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Sort weekdays by day number<\/h2>\n\n\n\n<p>Exit the Power Query Editor by pressing the button <strong>Close and apply<\/strong> to click.<\/p>\n\n\n\n<p>On the left side of the screen, select the pane <strong>Facts<\/strong>.<\/p>\n\n\n\n<p>Select the column <strong>Day number<\/strong>.<\/p>\n\n\n\n<p>Click in the Ribbon in the tab <strong>Column Tools<\/strong> on the button <strong>Sort by column<\/strong>.<\/p>\n\n\n\n<p>Choose the column from the drop-down menu <strong>Day number<\/strong>.<\/p>\n\n\n\n<p>Click on the left side of your screen <strong>Report<\/strong> to go to the pane <strong>Report<\/strong> to go. You will now see that all days are sorted by day number.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1901\" height=\"1011\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Power-BI-Sorteren-op-dagnummer.gif\" alt=\"Power BI - Sort by day number in Data pane\" class=\"wp-image-2437\"\/><figcaption class=\"wp-element-caption\">Power BI - Sort by day number in Data pane<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"downloads\"> <i class=\"fas fa-download\"><\/i> Downloads <\/h2>\n\n\n\n<p>If you can&#039;t figure it out with the above guide alone, download the sample file or ask a question by leaving a message.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-16c0121e-815d-4efd-8ef9-c8774382dbea\" href=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Valt-een-datum-in-het-weekend.zip\">Does a date fall on a weekend<\/a><a href=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/11\/Valt-een-datum-in-het-weekend.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-16c0121e-815d-4efd-8ef9-c8774382dbea\"><i class=\"fas fa-file-download\"><\/i> Download<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>Sometimes it can be useful to know whether a certain date falls on a weekend or not. It&#039;s possible\u2026 <a class=\"read-more\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/17\/falls-a-date-on-the-weekend-in-power-bi\/\">Continue reading<\/a><\/p>","protected":false},"author":1,"featured_media":2122,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[89],"tags":[102,90,94,101,103],"class_list":["post-2095","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-datum","tag-power-bi","tag-power-query","tag-sorteren","tag-weekdag"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.11 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Valt een datum in het weekend in Power BI<\/title>\n<meta name=\"description\" content=\"In dit artikel leg ik je uit hoe je aan de hand van een datum de dagnaam kunt laten weergeven en hoe je deze op volgorde kunt zetten in Power BI.\" \/>\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.bjorn-meijer.nl\/en\/2022\/11\/17\/falls-a-date-on-the-weekend-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Valt een datum in het weekend in Power BI\" \/>\n<meta property=\"og:description\" content=\"Soms kan het handig zijn om te weten of een bepaalde datum in het weekend valt of niet. Het kan zijn dat je wilt weten hoe vaak een bepaalde activiteit in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/17\/falls-a-date-on-the-weekend-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-17T06:13:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-17T08:55:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bj\u00f6rn Meijer\" \/>\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\":\"Article\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/\"},\"author\":{\"name\":\"Bj\u00f6rn Meijer\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"headline\":\"Valt een datum in het weekend in Power BI\",\"datePublished\":\"2022-11-17T06:13:09+00:00\",\"dateModified\":\"2022-11-17T08:55:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/\"},\"wordCount\":776,\"commentCount\":12,\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png\",\"keywords\":[\"datum\",\"power BI\",\"Power Query\",\"sorteren\",\"weekdag\"],\"articleSection\":[\"Power BI\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/\",\"name\":\"Valt een datum in het weekend in Power BI\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png\",\"datePublished\":\"2022-11-17T06:13:09+00:00\",\"dateModified\":\"2022-11-17T08:55:40+00:00\",\"description\":\"In dit artikel leg ik je uit hoe je aan de hand van een datum de dagnaam kunt laten weergeven en hoe je deze op volgorde kunt zetten in Power BI.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#primaryimage\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png\",\"contentUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png\",\"width\":300,\"height\":300,\"caption\":\"Power BI\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bjorn-meijer.nl\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Valt een datum in het weekend in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/de\/\",\"name\":\"Bj\u00f6rn Meijer\",\"description\":\"At My Playground\",\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\",\"name\":\"Bj\u00f6rn Meijer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"width\":165,\"height\":165,\"caption\":\"Bj\u00f6rn Meijer\"},\"logo\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.bjorn-meijer.nl\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Valt een datum in het weekend in Power BI","description":"In dit artikel leg ik je uit hoe je aan de hand van een datum de dagnaam kunt laten weergeven en hoe je deze op volgorde kunt zetten in Power BI.","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.bjorn-meijer.nl\/en\/2022\/11\/17\/falls-a-date-on-the-weekend-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Valt een datum in het weekend in Power BI","og_description":"Soms kan het handig zijn om te weten of een bepaalde datum in het weekend valt of niet. Het kan zijn dat je wilt weten hoe vaak een bepaalde activiteit in","og_url":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/17\/falls-a-date-on-the-weekend-in-power-bi\/","og_site_name":"Bj\u00f6rn Meijer","article_published_time":"2022-11-17T06:13:09+00:00","article_modified_time":"2022-11-17T08:55:40+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png","type":"image\/png"}],"author":"Bj\u00f6rn Meijer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bj\u00f6rn Meijer","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/"},"author":{"name":"Bj\u00f6rn Meijer","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"headline":"Valt een datum in het weekend in Power BI","datePublished":"2022-11-17T06:13:09+00:00","dateModified":"2022-11-17T08:55:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/"},"wordCount":776,"commentCount":12,"publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png","keywords":["datum","power BI","Power Query","sorteren","weekdag"],"articleSection":["Power BI"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/","url":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/","name":"Valt een datum in het weekend in Power BI","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png","datePublished":"2022-11-17T06:13:09+00:00","dateModified":"2022-11-17T08:55:40+00:00","description":"In dit artikel leg ik je uit hoe je aan de hand van een datum de dagnaam kunt laten weergeven en hoe je deze op volgorde kunt zetten in Power BI.","breadcrumb":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#primaryimage","url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png","contentUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png","width":300,"height":300,"caption":"Power BI"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/17\/valt-een-datum-in-het-weekend-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bjorn-meijer.nl\/de\/"},{"@type":"ListItem","position":2,"name":"Valt een datum in het weekend in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website","url":"https:\/\/www.bjorn-meijer.nl\/de\/","name":"Bj\u00f6rn Meijer","description":"At My Playground","publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615","name":"Bj\u00f6rn Meijer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","width":165,"height":165,"caption":"Bj\u00f6rn Meijer"},"logo":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.bjorn-meijer.nl"]}]}},"jetpack_featured_media_url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2022\/10\/powerbi-logo.png","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/2095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/comments?post=2095"}],"version-history":[{"count":9,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/2095\/revisions"}],"predecessor-version":[{"id":2445,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/2095\/revisions\/2445"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media\/2122"}],"wp:attachment":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media?parent=2095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/categories?post=2095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/tags?post=2095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}