Dax for 0 values with "Less Than 1" Text and remaining values leave it as it is??

[Ayyappa5678]

Hi Team,

I am new to power bi, Please help me on below scenario.

Sub: -Instead of 0 change to Less Than 1. and remaining values leave it as it is.

A column of "0" value need to change with Text of like "Less Than 1" and remaing values need to leave it as it is, like below snapshot of result value.

Kindly help me on this case?

[tackytechtom]

Hi @Ayyappa5678 ,

How about this:

And here the DAX for a calculated column:

Column = if ( 'Table'[Values] < 1, "Less Than 1", CONVERT('Table'[Values], STRING ) )

Let me know if ths helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/