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,
I have more than 500 different values in a column and I need to replace all of them for a single value in a new column. How can I do that easily? Is there such a function as replace all values except blank, for a unique value?
Thanks, RA
Solved! Go to Solution.
hi @Anonymous
try calculated column
Column = IF(
isBlank('Table'[Field]);blank();"YourNewValue")
)
do not hesitate to give a kudo to useful posts and mark solutions as solution
hi @Anonymous
it should work
= if [Column1] = null then null else "YourValue"
do not hesitate to give a kudo to useful posts and mark solutions as solution
Follow the following. Remember you need to add several entries then the system makes a rule and follows the rule.
hi @Anonymous
try calculated column
Column = IF(
isBlank('Table'[Field]);blank();"YourNewValue")
)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi AZ38 -
How can I apply this same formula in the POWER QUERY EDITOR?
In my specific case, it would be better to do this there, by addin a Custom column.\
Pls, let me know.
Thank you. RA
hi @Anonymous
it should work
= if [Column1] = null then null else "YourValue"
do not hesitate to give a kudo to useful posts and mark solutions as solution
SUPER!!!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |