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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.