Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi There,
I have a very annoying issue. I try to create a calculated column wherein values are appointed to different bins.
I look up if a value in TAT IR is less than 5. If "True" than it should be tagged with the "0-5" category. However all values with a TAT IR with 0 are not recognized.
TAT IR Column is formated as whole number.
Any a suggestion what could be the problem ?
many thanks in advance,
Solved! Go to Solution.
Hi @UnclePaul,
It looks like zero is recognized as Blank(), but different from null value. I cannot either distinguish them well, but you could try below DAX formula:
TAT IR bins2 = IF ( NOT ( ISBLANK ( Table2[TAT IR] ) ), IF ( Table2[TAT IR] <= 5, "0-5", IF ( Table2[TAT IR] <= 10, "6-10", ">10" ) ) )
Best regards,
Yuliana Gu
Hi @UnclePaul,
It looks like zero is recognized as Blank(), but different from null value. I cannot either distinguish them well, but you could try below DAX formula:
TAT IR bins2 = IF ( NOT ( ISBLANK ( Table2[TAT IR] ) ), IF ( Table2[TAT IR] <= 5, "0-5", IF ( Table2[TAT IR] <= 10, "6-10", ">10" ) ) )
Best regards,
Yuliana Gu
Thanks a lot, that did the job.
Still cannot understand why this occurs...a bit strange though..
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |