cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sun-and-sea
Regular Visitor

Error message for SWITCH function

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.

 

sunandsea_0-1627485704941.png

 

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.

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Greg_Deckler
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

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.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.