Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm having a problem with a if statement.
It's seems simple but not or I'm making a mistake.
1 field (whole number) : Response tag
The new column is
Solved! Go to Solution.
@Anonymous not ideal but can you +0 to the end of it and see if that fixes it?
Proud to be a Super User!
Hi @Anonymous ,
Please try using your expression with out VALUE keyword. I hope it will give you expected result.
Hello @Anonymous ,
This actually looks wierd. Might need more details though.
In the mean time, please try the below options -
1. IF([Response Tag]>0,0,1)
2. IF([Response Tag]<=0,1,0)
Hope, this will help!
@Anonymous what data type is the responsetag?
can you paste some of your data, i have tried to replicate your issue but not coming up with the same problem, wondering if its an underlying issue in your data
Proud to be a Super User!
Here is a sample of my data
1.
Response target
20/01/2019 16:00:00
Response Stop
27/01/2019 05:05:05
Response Tag : -2095
= IF([ResponseTargetDate]<>BLANK(),DATEDIFF([ResponseTargetDate],[ResponseSLAStoppedDate],MINUTE),0)
Status_SLA_Response: 0
i have put your data into a model and am not experiencing what you are
see attached, how does this differ from what you doing @Anonymous
Proud to be a Super User!
Thx Vanessa,
It's exactly what I'm doing.
To get the wrong result, I put the cursor to the rigth of the formula
@Anonymous and if you open my power bi, does it look correct? does it show the right values?
Proud to be a Super User!
Yes, it shows the right result but when a click on the Entre key just after the formula, it becomes wrong also.
It seems to be a problem with the IF statement because only the first <value_if_true> is displayed.
If I change to IF([Response Tag]<0,1,0), I get ones and blanks.
With IF([Response Tag]<0,0,1), I get zeros and blanks.
@Anonymous not ideal but can you +0 to the end of it and see if that fixes it?
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |