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 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?
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |