Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!!!
Solved! Go to 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.
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
Thank you amitchandak but I don't want to create a new column, I need to replace the value.
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.