Forum Discussion
Decimal condition in DAX
I want to add a condition in dax where [columnname] is either less than 0 or equal to 0 or equal to 0.0 or equal to 0.00.
Please suggest!
Wrapping it in INT() should have the same effect on a numeric column.
4 Replies
The only way you can display a number like 0.0 is if it is in a text column, other wise it will display as 0.
I made a small sample that has the values you are asking about in a text column. I added a calculated column to test if they were greater than zero (1 = true, 0 = false).
In order to do the "greater than" operation I had to use the INT() function to convert the test values to integers
Hope that answers your question.
I'm a personal Power BI trainer.Is the column a text column or a numeric column ?
Wrapping it in INT() should have the same effect on a numeric column.