How to use greater than to or equal (>=) and less than or equal to (<=)

Questions & Answers
1

CASE
WHEN [Measures].[Issues created] >= 97 and [Measures].[Issues created] =< 100 then ‘Expected’
ELSE 0
END
Error

2

In your formula you mixed up the order, it should be <= not =<

You will then run in another error because you show a string in the THEN-case but a number in the ELSE-case. It should be both string or number.

1 Like
3

Silly me, how could I not notice that? :sweat_smile:

Thanks @sven!