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.
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!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |