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,
How to convert "99990.0%" to NA, others remain same? I tried to use if statement, but got error message. Thanks!
Hi @Anonymous,
If values 999900.0% and 100.0% come from a measure, you can modify the measure like below:
Measure=IF(MAX(Table1[Column1])=9999,"N/A",MAX(Table1[Column1]))
Best Regards,
Qiuyun Yu
Hi Yu,
thanks for reply. The column comes from table(not calculated measure or calculated column). I applied the formular "Measure=IF(MAX(Table1[Column1])=9999,"N/A",MAX(Table1[Column1]))"
which you provided , but I got the error message:
I can't replace 99999 to 0, have to replace 9999 to NA for business purpose. Another solution?
Thanks!
@Anonymous,
Please do try the below one,
Measure=IF(MAX(Table1[Column1])=9999,"N/A",FORMAT(MAX(Table1[Column1],"0.0%")))
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |