Forum Discussion
ReplaceValue many collumns if is not null
Hi again folks.
I need to replace "NOT(null")" in many collumns for "Grey" using powerquery.
For example:
This
| COLUMN 01 | COLUMN 02 | COLUMN 03 |
| null | ghi | null |
| abc | null | mno |
| def | jkl | null |
In that:
| COLUMN 01 | COLUMN 02 | COLUMN 03 |
| null | Grey | null |
| Grey | null | Grey |
| Grey | Grey | null |
Ty guys!!!
Hi Anonymous ,
Given that there is not a "replace all not null values" option in Power Query, you could try to change data type and replace the errors to implement it.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
if(table[column]<> null, "Grey")
Refer how to use
https://www.myonlinetraininghub.com/power-query-if-statements
https://community.powerbi.com/t5/Desktop/IF-Statement-using-Power-Query/td-p/122030
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on LinkedinThank you amitchandak but I don't want to create a new column, I need to replace the value.
v-xuding-msftCommunity Support
Hi Anonymous ,
Given that there is not a "replace all not null values" option in Power Query, you could try to change data type and replace the errors to implement it.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
