Replace a Value from one ROW

[Anonymous]

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	Carlos	1
4	Jose	1

As you see All Juan Lucia and Jose have Carlos as manager and Carlos´s Manager ID is wrong but if i change it i change all values number "1"

Is there a solution?

Thanks!

[Cmcmahan · Accepted solution]

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