I'm surprised to find that Power Fx has no way to express these values. I'd propose adding the following.
| Expression |
Description |
| Infinity |
Numeric literal for positive infinity |
| -Infinity |
Numeric literal for negative infinity |
| Epsilon() |
Returns the smallest positive value greater than zero |
| MaxValue() |
Returns the largest possible numeric value |
| MinValue() |
Returns the smallest possible numeric value |
NaN is also worth considering, but I believe that's already handled as an error value.
Pi() already exists.
I'm surprised to find that Power Fx has no way to express these values. I'd propose adding the following.
NaNis also worth considering, but I believe that's already handled as an error value.Pi()already exists.