ReplaceValue many collumns if is not null

[Anonymous]

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!!!

[amitchandak]

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 Linkedin

[Anonymous]

Thank you amitchandak but I don't want to create a new column, I need to replace the value.

[v-xuding-msft · Accepted solution]

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.