Forum Discussion
Problems with Infinite value and NaN value
Hi
I am trying to make a simple devision in PowerBI, by adding a new column (see column below: Area / (DIR/2). This column is calculated by deviding the column "Area" by column "DIR/2".
For some of the rows the calculation works fine, but for 1 row the value returned says "Infinte" and for another row the value returned is NaN. Anybody who can help?
Please see the attached table
Niels
Anonymous
Use DIVIDE() and proper Parentheses.
DIVIDE(<numerator>, <denominator> [,<alternateresult>])Check out the below links
https://docs.microsoft.com/en-us/dax/divide-function-dax
https://docs.microsoft.com/en-us/power-bi/guidance/dax-divide-function-operator
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
2 Replies
- nandukrishnavs
Community Champion
Anonymous
Use DIVIDE() and proper Parentheses.
DIVIDE(<numerator>, <denominator> [,<alternateresult>])Check out the below links
https://docs.microsoft.com/en-us/dax/divide-function-dax
https://docs.microsoft.com/en-us/power-bi/guidance/dax-divide-function-operator
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂