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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
omkarsawant30
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.

 

 

1 REPLY 1
omkarsawant30
Frequent Visitor

@amitchandak Please check this query

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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