Update Structured

[Polamounir]

Dear All

I need a little help. I have Data set with 2 tables, One for Sales and the other for the sales team structure " Agent - Manager - Director " 

Currently, I have a challenge where one of the directors has left so his managers are transferred to other existing Director 

I need to calculate the sales based on the new structure keeping the old sales for the leaving director not calculated for the transferred director 

Any One can Help 

[Idrissshatila]

Hello @Polamounir ,

if you can't change it from the datasource, then go to power query and replace the old manager name with the one you want to using replace values function.

refer to this link for instructions https://learn.microsoft.com/en-us/power-query/replace-values

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin