DAX calculated column code to add business days or network days to a date.
<\/p>\n\n\n\n
VAR __Date = IF(Table1[StartDate] <> BLANK(), Table1[StartDate], date(2000, 1, 1))
\/\/ Days to Add; in my use case, the # of days was dependent on a category value. You can just set this a specific number if applicable<\/p>\n\n\n\n
VAR __Days = SWITCH(TRUE(),<\/p>\n\n\n\n
\u00a0 [Category] = “Complex”, 43,<\/p>\n\n\n\n
\u00a0 [Category] = “Moderate”, 31,<\/p>\n\n\n\n
\u00a0 [Category] = “Simple”, 29,<\/p>\n\n\n\n
\u00a0 \u00a0 )
\/\/ This var creates a temp calendar padded out by the *3 <\/p>\n\n\n\n
VAR __Calendar = ADDCOLUMNS(CALENDAR(__Date, __Date + (__Days) * 3), “Weekday” , WEEKDAY([Date],2))
\/\/ filter out the weekends<\/p>\n\n\n\n
VAR __CalendarX = FILTER(__Calendar, [Weekday] < 6)
\/\/ add an addition column to the temp calendar that counts the # of days needed.<\/p>\n\n\n\n
\u00a0VAR __CalendarY = ADDCOLUMNS(__CalendarX,\u00a0 “Days”, COUNTROWS(FILTER(__CalendarX, [Date] <= EARLIER([Date]))<\/p>\n\n\n\n
)<\/p>\n\n\n\n
)<\/p>\n\n\n\n
RETURN
\/\/ returns the new ‘due’ date that is __Days out from the StartDate.<\/p>\n\n\n\n
\u00a0 \u00a0SELECTCOLUMNS(FILTER(__CalendarY, [Days] = __Days), “Date”, [Date])<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
DAX calculated column code to add business days or network days to a date. VAR __Date = IF(Table1[StartDate] <> BLANK(), Table1[StartDate], date(2000, 1, 1)) \/\/ Days to Add; in my use case, the # of days was dependent on a category value. You can just set this a specific number […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-744","post","type-post","status-publish","format-standard","hentry","category-power-bi"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=744"}],"version-history":[{"count":0,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/744\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}