Forum Discussion
IF AND STATEMENT Measure Power Query
I have two columns: 1. predicted precipitation (Table1[Prediction]) and 2. actual precipitation (Table2[Real]) and I want to test 4 conditions: a. predicted precipitation/observed precipitation b. ...
Hi,
i hope this time it's good (i printed your solution to verify)
P = IF('Table'[Column1]=0,1,If(and('Table'[Column1]>=0,'Table'[Column2]>0),0,1))
Thank you for another suggestion. However, the result is the same. If you notice in the table you shared with me, the result is still "0" instead of "1".
Hi,
i hope this time it's good (i printed your solution to verify)
P = IF('Table'[Column1]=0,1,If(and('Table'[Column1]>=0,'Table'[Column2]>0),0,1))
Thank you once again. I see that in your table, the formula works, but in mine, unfortunately not. I still get 0. I don't understand why.
Please post the new formula you are using
I already know why it didn't work and it's embarrassing. It wasn't a 0, but a 0.3 the prediction. I apologize for wasting your time. Thank you very much for your help.