Error message for SWITCH function

[sun-and-sea]

Hi everyone,

I've tried to use the SWITCH function to replace nested multiple IF statements here. My goal is to categorize the times emails were sent into Morning, Afternoon, Evening, etc.

Regardless of me creating this function as a New Measure or a New Column, the same error message kept appearing.

"Operator or expression '()' is not supported in this context."

I tried writing the formula with and without indents, replaced the "" part at the end into BLANK(), but nothing has worked yet...

I'd really appreciate your help!

Thank you.

[Greg_Deckler · Accepted solution]

@sun-and-sea I see two problems potentially. One, in the last line, you seem to be missing a TIME function, TIME(21, 30, 00). Two, if this is a measure, you are missing aggregations around your column references. Time Sent.

[sun-and-sea]

Hi Greg,

I've corrected my function following your suggestions:

Segment =

SWITCH (

TRUE(),

MIN('Publication Subscriber'[Time Sent]) >= TIME(00,00,00) && MIN('Publication Subscriber'[Time Sent]) < TIME(08,00,00),"Early Morning",

MIN('Publication Subscriber'[Time Sent]) >= TIME(08,00,00) && MIN('Publication Subscriber'[Time Sent]) < TIME(12,00,00),"Morning",

MIN('Publication Subscriber'[Time Sent]) >= TIME(12,00,00) && MIN('Publication Subscriber'[Time Sent]) < TIME(17,30,00),"Afternoon",

MIN('Publication Subscriber'[Time Sent]) >= TIME(17,30,00) && MIN('Publication Subscriber'[Time Sent]) < TIME(21,30,00),"Evening",

MIN('Publication Subscriber'[Time Sent]) >= TIME(21,30,00) && MIN('Publication Subscriber'[Time Sent]) < TIME(00,00,00),"Late Evening",

BLANK()

)

It worked! Thank you for your help!

Best.