Forum Discussion
Replace a Value from one ROW
Hi, I´ve been trying to replace a value from one row only but if the value is on another row it will replace both values. Example: ID Name Manager ID 3 Juan 1 2 Lucia 1 1 Car...
The best (and easiest) solution is to fix it in your source data and re-import it into PowerBI.
If you 100% absolutely MUST change it in PowerBI, you can do it by creating a custom column in PowerQuery. Try following this example, and if there are further questions, ask them here: https://community.powerbi.com/t5/Desktop/Replacing-just-1-value-in-a-table/td-p/75871
The best (and easiest) solution is to fix it in your source data and re-import it into PowerBI.
If you 100% absolutely MUST change it in PowerBI, you can do it by creating a custom column in PowerQuery. Try following this example, and if there are further questions, ask them here: https://community.powerbi.com/t5/Desktop/Replacing-just-1-value-in-a-table/td-p/75871