Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
136 | |
73 | |
72 | |
55 | |
55 |
User | Count |
---|---|
199 | |
95 | |
63 | |
62 | |
51 |