Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi @Paulyeo11 ,
Let's speak in mathematical language :
[-100, 0) and [0,100] range has been fully covered by your expression.
So you could rewritten the second expression as <100 &&>=0
Did I answer your question ? Please mark my reply as solution. Thank you very much. If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi @Paulyeo11 ,
Let's speak in mathematical language :
[-100, 0) and [0,100] range has been fully covered by your expression.
So you could rewritten the second expression as <100 &&>=0
Did I answer your question ? Please mark my reply as solution. Thank you very much. If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |