Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago
Status:
Accepted

DATE in DATATABLE not working

The documentation here:   https://msdn.microsoft.com/en-us/library/mt674921.aspx   Says that DATE(2009,1,1) is a valid value, but this returns an error.   VAR Holidays = DATATABLE("Date",DATETI...
Data Modeling
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

OK, so the following works: I will see about updating my Quick Measure in the Gallery. Thanks!

 

NetWorkDaysHolidays = 
VAR Calendar1 = CALENDAR(MAX(NetWorkDays[created date]),MAX(NetWorkDays[review date]))
//VAR Holidays = DATATABLE("Date",DATETIME,{{}})
VAR Holidays = DATATABLE("Date",DATETIME,
    {
        {"12/25/2017 12:00:00 AM"}
    })
VAR Calendar2 = EXCEPT(Calendar1,Holidays)
VAR Calendar3 = ADDCOLUMNS(Calendar2,"WeekDay",WEEKDAY([Date],2))
RETURN COUNTX(FILTER(Calendar3,[WeekDay]<6),[Date])

 

Completed Ideas