Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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 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.
Hi Greg,
I've corrected my function following your suggestions:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |