{"id":3332,"date":"2021-06-22T12:40:17","date_gmt":"2021-06-22T12:40:17","guid":{"rendered":"https:\/\/iberico.nl\/calendar\/"},"modified":"2023-10-27T14:36:21","modified_gmt":"2023-10-27T14:36:21","slug":"calendar","status":"publish","type":"page","link":"https:\/\/iberico.nl\/en\/calendar\/","title":{"rendered":"calendar"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.9.7″ _module_preset=”default”][et_pb_row _builder_version=”4.9.7″ _module_preset=”default”][et_pb_column _builder_version=”4.9.7″ _module_preset=”default” type=”4_4″][et_pb_text _builder_version=”4.9.7″ _module_preset=”default” hover_enabled=”0″ sticky_enabled=”0″]<\/p>\n

DIM_Calendar = ADDCOLUMNS(CALENDAR(MIN(FactTable[Datum]),DATE(YEAR(TODAY())+1,12,31)),<\/p>\n

\/\/ The above line picks the lowest date from the fact table (modify this) and the last day of next year.<\/p>\n

 <\/p>\n

“Year” , YEAR ([Date]) ,<\/p>\n

“Quarter” , CONCATENATE(“Q”,ROUNDUP(MONTH([Date])\/3,0)),<\/p>\n

“Month” , MONTH([Date]),<\/p>\n

“Month name”, IF(MONTH([Date]) = 1, “Jan,” IF(MONTH([Date]) = 2, “Feb,” IF(MONTH([Date]) = 3, “Maa”, IF(MONTH([Date]) = 4, “Apr”,IF(MONTH([Date]) = 5, “May,” IF(MONTH([Date]) = 6, “Jun,” IF(MONTH([Date]) = 7, “Jul,” IF(MONTH([Date]) = 8, “Aug,” IF(MONTH([Date]) = 9, “Sep,” IF(MONTH([Date]) = 10, “Oct,” IF(MONTH([Date]) = 11, “Nov,” IF(MONTH([Date]) = 12, “Dec,” BLANK ())))))))))))),<\/p>\n

“Week” , WEEKNUM([Date],21),<\/p>\n

“Weekday” , WEEKDAY([Date],2),<\/p>\n

“Day” , DAY([Date]),<\/p>\n

“Year-Month” , (YEAR([Date])*100) + MONTH([Date]),<\/p>\n

“Year-Week” , (YEAR([Date])*100) + WEEKNUM([Date],21),<\/p>\n

“YearsBack” , CONVERT(YEAR(TODAY())) – YEAR([Date]),STRING),<\/p>\n

“MonthsBack” , CONVERT(DATEDIFF( [Date],TODAY(),MONTH),STRING),<\/p>\n

“WeeksBack” , CONVERT(ROUNDUP(DATEDIFF( [Date], TODAY() + (8 – WEEKDAY(TODAY(),2)),DAY) \/ 7,0)-1,STRING),<\/p>\n

“DaysBack” , DATEDIFF( [Date],TODAY(),DAY),<\/p>\n

“YearToDate”, IF([Date] >= DATE(YEAR(TODAY()),1,1) && [Date] <= TODAY(), “Yes”, “No”),<\/p>\n

“Finished months,” IF([Date] >= DATE(YEAR(TODAY()),1,1) && [Date] <= TODAY() && MONTH([Date]) < MONTH(TODAY()), “Yes”, “No”),<\/p>\n

“Finished months years”, IF(MONTH([Date]) < MONTH(TODAY()), “Yes”, “No”),<\/p>\n

“LastYearToDate”, IF([Date] >= DATE(YEAR(TODAY())-1,1,1) && [Date] <= DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())), “Yes”, “No”),<\/p>\n

“Today,” IF([Date] = TODAY(), “Yes,” “No”),<\/p>\n

“Yesterday,” IF([Date] = TODAY()-1, “Yes,” “No”),<\/p>\n

“This week,” IF(ROUNDUP(DATEDIFF( [Date], TODAY() + (8 – WEEKDAY(TODAY(),2)),DAY) \/ 7,0) = 1, “Yes,” “No”),<\/p>\n

“Last week,” IF(ROUNDUP(DATEDIFF( [Date], TODAY() + (8 – WEEKDAY(TODAY(),2)),DAY) \/ 7,0) = 2, “Yes,” “No”),<\/p>\n

“This month”, IF(DATEDIFF([Date],TODAY(),MONTH) = 0, “Yes”, “No”),<\/p>\n

“Previous month”, IF(DATEDIFF([Date],TODAY(),MONTH) = -1, “Yes”, “No”),<\/p>\n

“This year,” IF(DATEDIFF([Date],TODAY(),YEAR) = 0, “Yes,” “No”)<\/p>\n

)<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.9.7″ _module_preset=”default” hover_enabled=”0″ sticky_enabled=”0″]<\/p>\n

\n
DIM_DateFilters = UNION(FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[YearToDate], “Label”, “Year To Date”),[FilterColumn] = “Yes”),<\/span><\/div>\n
FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[LastYearToDate], “Label”, “Last Year To Date”),[FilterColumn] = “Yes”),<\/span><\/div>\n
FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[Vandaag], “Label”, “Today”),[FilterColumn] = “Yes”),<\/span><\/div>\n
FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[Gisteren], “Label”, “Yesterday”),[FilterColumn] = “Yes”),<\/span><\/div>\n
FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[Deze week], “Label”, “This Week”),[FilterColumn] = “Yes”),<\/span><\/div>\n
FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[Deze week], “Label”, “All Dates”),[FilterColumn] IN {“Yes”, “No”}),<\/span><\/div>\n
FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[Afgesloten maanden], “Label”, “Finished months”),[FilterColumn] = “Yes”),<\/span><\/div>\n
FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[Vorige maand], “Label”, “Previous Month”),[FilterColumn] = “Yes”),<\/span><\/div>\n
FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[Deze maand], “Label”, “This Month”),[FilterColumn] = “Yes”),<\/span><\/div>\n
FILTER(SELECTCOLUMNS(DIM_Calendar, “Date”,[Date], “FilterColumn”,[Dit jaar], “Label”, “This Year”),[FilterColumn] = “Yes”))<\/span><\/div>\n<\/div>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

DIM_Calendar = ADDCOLUMNS(CALENDAR(MIN(FactTable[Datum]),DATE(YEAR(TODAY())+1,12,31)), \/\/ The above line picks the lowest date from the fact table (modify this) and the last day of next year.   “Year” , YEAR ([Date]) , “Quarter” , CONCATENATE(“Q”,ROUNDUP(MONTH([Date])\/3,0)), “Month” , MONTH([Date]), “Month name”, IF(MONTH([Date]) = 1, “Jan,” IF(MONTH([Date]) = 2, “Feb,” IF(MONTH([Date]) = 3, “Maa”, IF(MONTH([Date]) = 4, “Apr”,IF(MONTH([Date]) = […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-3332","page","type-page","status-publish","hentry"],"yoast_head":"\ncalendar - Power BI<\/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:\/\/iberico.nl\/en\/calendar\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"calendar - Power BI\" \/>\n<meta property=\"og:description\" content=\"DIM_Calendar = ADDCOLUMNS(CALENDAR(MIN(FactTable[Datum]),DATE(YEAR(TODAY())+1,12,31)), \/\/ The above line picks the lowest date from the fact table (modify this) and the last day of next year.   "Year" , YEAR ([Date]) , "Quarter" , CONCATENATE("Q",ROUNDUP(MONTH([Date])\/3,0)), "Month" , MONTH([Date]), "Month name", IF(MONTH([Date]) = 1, "Jan," IF(MONTH([Date]) = 2, "Feb," IF(MONTH([Date]) = 3, "Maa", IF(MONTH([Date]) = 4, "Apr",IF(MONTH([Date]) = […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/iberico.nl\/en\/calendar\/\" \/>\n<meta property=\"og:site_name\" content=\"Power BI\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T14:36:21+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/iberico.nl\/en\/calendar\/\",\"url\":\"https:\/\/iberico.nl\/en\/calendar\/\",\"name\":\"calendar - Power BI\",\"isPartOf\":{\"@id\":\"https:\/\/iberico.nl\/en\/#website\"},\"datePublished\":\"2021-06-22T12:40:17+00:00\",\"dateModified\":\"2023-10-27T14:36:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/iberico.nl\/en\/calendar\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/iberico.nl\/en\/calendar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/iberico.nl\/en\/calendar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/iberico.nl\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"calendar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/iberico.nl\/en\/#website\",\"url\":\"https:\/\/iberico.nl\/en\/\",\"name\":\"Power BI\",\"description\":\"Power BI Dashboards\",\"publisher\":{\"@id\":\"https:\/\/iberico.nl\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/iberico.nl\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/iberico.nl\/en\/#organization\",\"name\":\"Iberico\",\"url\":\"https:\/\/iberico.nl\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/iberico.nl\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/iberico.nl\/wp-content\/uploads\/2020\/12\/Logo_Iberico-donker-blauw-e1607338095420.png\",\"contentUrl\":\"https:\/\/iberico.nl\/wp-content\/uploads\/2020\/12\/Logo_Iberico-donker-blauw-e1607338095420.png\",\"width\":250,\"height\":78,\"caption\":\"Iberico\"},\"image\":{\"@id\":\"https:\/\/iberico.nl\/en\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"calendar - 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:\/\/iberico.nl\/en\/calendar\/","og_locale":"en_US","og_type":"article","og_title":"calendar - Power BI","og_description":"DIM_Calendar = ADDCOLUMNS(CALENDAR(MIN(FactTable[Datum]),DATE(YEAR(TODAY())+1,12,31)), \/\/ The above line picks the lowest date from the fact table (modify this) and the last day of next year.   \"Year\" , YEAR ([Date]) , \"Quarter\" , CONCATENATE(\"Q\",ROUNDUP(MONTH([Date])\/3,0)), \"Month\" , MONTH([Date]), \"Month name\", IF(MONTH([Date]) = 1, \"Jan,\" IF(MONTH([Date]) = 2, \"Feb,\" IF(MONTH([Date]) = 3, \"Maa\", IF(MONTH([Date]) = 4, \"Apr\",IF(MONTH([Date]) = […]","og_url":"https:\/\/iberico.nl\/en\/calendar\/","og_site_name":"Power BI","article_modified_time":"2023-10-27T14:36:21+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/iberico.nl\/en\/calendar\/","url":"https:\/\/iberico.nl\/en\/calendar\/","name":"calendar - Power BI","isPartOf":{"@id":"https:\/\/iberico.nl\/en\/#website"},"datePublished":"2021-06-22T12:40:17+00:00","dateModified":"2023-10-27T14:36:21+00:00","breadcrumb":{"@id":"https:\/\/iberico.nl\/en\/calendar\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/iberico.nl\/en\/calendar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/iberico.nl\/en\/calendar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/iberico.nl\/en\/"},{"@type":"ListItem","position":2,"name":"calendar"}]},{"@type":"WebSite","@id":"https:\/\/iberico.nl\/en\/#website","url":"https:\/\/iberico.nl\/en\/","name":"Power BI","description":"Power BI Dashboards","publisher":{"@id":"https:\/\/iberico.nl\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/iberico.nl\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/iberico.nl\/en\/#organization","name":"Iberico","url":"https:\/\/iberico.nl\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/iberico.nl\/en\/#\/schema\/logo\/image\/","url":"https:\/\/iberico.nl\/wp-content\/uploads\/2020\/12\/Logo_Iberico-donker-blauw-e1607338095420.png","contentUrl":"https:\/\/iberico.nl\/wp-content\/uploads\/2020\/12\/Logo_Iberico-donker-blauw-e1607338095420.png","width":250,"height":78,"caption":"Iberico"},"image":{"@id":"https:\/\/iberico.nl\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/iberico.nl\/en\/wp-json\/wp\/v2\/pages\/3332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iberico.nl\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/iberico.nl\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/iberico.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iberico.nl\/en\/wp-json\/wp\/v2\/comments?post=3332"}],"version-history":[{"count":5,"href":"https:\/\/iberico.nl\/en\/wp-json\/wp\/v2\/pages\/3332\/revisions"}],"predecessor-version":[{"id":3337,"href":"https:\/\/iberico.nl\/en\/wp-json\/wp\/v2\/pages\/3332\/revisions\/3337"}],"wp:attachment":[{"href":"https:\/\/iberico.nl\/en\/wp-json\/wp\/v2\/media?parent=3332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}