topic Re: Error message for SWITCH function in DAX Commands and Tips

Error message for SWITCH function

Anonymous — Wed, 28 Jul 2021 15:25:08 GMT

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.

Re: Error message for SWITCH function

Greg_Deckler — Wed, 28 Jul 2021 15:55:20 GMT

Anonymous 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.

Re: Error message for SWITCH function

Anonymous — Wed, 28 Jul 2021 20:28:19 GMT

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.