Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All, I want to Replace these -2 values with N/A, Is there any possible way to replace numerical values with text as N/A values
Thanks
@Alan p James
Solved! Go to Solution.
You could create a custom column which is null if the value of the base column is less than 0 else it is the current value of your base column. Then you can delete the base column and rename the new one.
Could you please show one demo
Using Replace Values in Power Query you can use "null" as the replace with value and it won't break the number formating of the column,
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
81 | |
65 | |
64 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |