Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

How to replace errors in a column based on a filter applied in another column?

I have found errors in my dataset for a column ID. I need to replace those errors with 2 values based on corresponding row value of another column 'Name', however when i go to Transform - Replace values, it only allows to replace all errors together with only 1 value that you can input, but i want to input 2 values conditionally , input DC1 for few rows in ID column that has cell value ABC in 'Name' column and DC2 for remaining rows with errors in ID column which has value XYZ in 'Name' column.



Frequent Visitor

@amitchandak Please check this query

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors