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.
Hi,
I have a table with two columns that represent Upper and Lower Limits for measurement values of a system. The limit values can be valid integer values, Blank or (+/-)Infinity. I want to check for the following -
a. If both the values are not Infinity or blank.
b. If one of the values is not Infinity or blank.
c. If both the values are Infinity or blank.
I am using the ISBLANK function to cover the check for blank but can't find a function for Infinity something similar to ISNAN. Anybody know of a way to check for Infinity values.
Regards,
Sunil
Solved! Go to Solution.
I think infinite values will read as errors, so ISERROR(TableName[ColumnName]) should do it. Otherwise you could try NOT(ISNUMBER(TableName[ColumnName]))
Proud to be a Super User!
Thanks for sharing download the share it app for that transfer from the given link it's one the best alternative to the other data transfer apps like airdroid and xender ans pushbullet too... http://shareit-app.com
Thanks for sharing download the share it app for that transfer from the given link it's one the best alternative to the other data transfer apps like airdroid and xender ans pushbullet too :.. Download the app from the below given link : https://www.shareitforwindows.com/
I think infinite values will read as errors, so ISERROR(TableName[ColumnName]) should do it. Otherwise you could try NOT(ISNUMBER(TableName[ColumnName]))
Proud to be a Super User!
Share it app for that transfer from the given link it's one the best alternative to the other data transfer apps like airdroid and xender ans pushbullet too :.. Download the app from the below given link : https://www.shareitforwindows.com/
Thanks for sharing download the share it app for that transfer from the given link it's one the best alternative to the other data transfer apps like airdroid and xender ans pushbullet too :.. Download the app from the below given link : https://www.shareitforwindows.com/
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |