Switch Formula error message

[Anonymous]

Hello, 

Using the following formula (adding calculated column to my date table) which I thought should work, but getting an error message.   If I just put  Blank() )   the syntax does not show me any error message when writing the formula, but as soon as I hit enter, it adds all of these  )))))) with the last one showing the dreaded red squiggly line and then this error message.  

Any ideas why?    Am I perhaps missing something after the Blank() ?   

[danextian]

Hello @Anonymous 

DATE() function returns a date and will require these numeric inputs: Year, Month, Day. You may use the simplied formula below:

Weekend or Weekday =
IF (
    DataTable[DayInWeek] = 0
        || DataTable[DayInWeek] = 6,
    "Weekend",
    "Weekday"
)

Or use a longer one:

Weekend or Weekday =
SWITCH (
    TRUE (),
    DataTable[DayInWeek] = 1, "Weekday",
    DataTable[DayInWeek] = 2, "Weekday",
    DataTable[DayInWeek] = 3, "Weekday",
    DataTable[DayInWeek] = 4, "Weekday",
    DataTable[DayInWeek] = 5, "Weekday",
    DataTable[DayInWeek] = 6, "Weekday",
    DataTable[DayInWeek] = 0, "Weekday"
)

[Anonymous]

@Anonymous , DATE() is a function that returns a date when you supply a year, month, and day.

DATE(2020, 2, 14) returns February 14, 2020, formatted as a date.

This calculated column will give you what you're looking for:

Weekend or Weekday = 
IF(
	DateTable[DayInWeek] = 0
		|| DateTable[DayInWeek] = 6
	,"Weekend"
	,"Weekday"
)

[KHorseman]

You didn't close the parentheses on all those DATE( formulas. Should be DATE(DateTable[DayInWeek]).

[Anonymous · Accepted solution]

I answered my own question.   

Did not need to put "DATE" in front.    And did not need parenthesis.  

[Anonymous]

I tried that....but immediately get a red line....??

[KHorseman]

Oh right, I think you want DAY, not DATE.