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.
Hello Everyone,
I have created a if formula and i am not getting the right result.Below is my if formula
If_Formula = IF((By_Emp[Total_hrs]<By_Emp[Avail_Hrs]),"Missing","Correct")
Difference = By_Emp[Avail_Hrs]-By_Emp[Total_hrs]
If you see the screen shot below, difference is 0. So accordig to my IF formula it shows Missing in last column. I think it should be showing Correct in last column. Am i missing something here?
Solved! Go to Solution.
Hi skanchan,
I have reproduced your issue.
You are using a table visual like below, right?
See the original table, please check if the length of mantissa in a decimal is more than 2 because the table visual will emit several digits based on your setting which may mislead you.
To see the correct result in table visual, click Modeling->Format->Change the number of decimal places.
Regards,
Jimmy Tao
Hi skanchan,
I have reproduced your issue.
You are using a table visual like below, right?
See the original table, please check if the length of mantissa in a decimal is more than 2 because the table visual will emit several digits based on your setting which may mislead you.
To see the correct result in table visual, click Modeling->Format->Change the number of decimal places.
Regards,
Jimmy Tao
Well I tested the same at my end. Didn't find anything wrong with your formula.
Maybe you can try this If_Formula = IF([Difference]>0,"Missing","Correct") or If_Formula = IF(((By_Emp[Total_hrs]-By_Emp[Avail_Hrs])<0),"Missing","Correct")
@HardikThanks for your reply.
Strange that it work at your end.
I dont want to use the difference colume because i created that column just to help troubleshoot the issue.
@Anonymous Try this If_Formula = IF(((By_Emp[Total_hrs]-By_Emp[Avail_Hrs])<0),"Missing","Correct"), it should work.
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 |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |