NEED HELP with Power BI query optimization

[ncordova]

Hi Guys,

I'm quite new in PowerB
need your expertise to resolve this scenario:

Thank you and best regards,
Norman

[v-yulgu-msft]

Hi @ncordova,

Please explain why "Earl" is changed to "Jose". We need more details about your requirement.

Regards,

Yuliana Gu

[ncordova]

Hi Yuliana,

What happen is, there was a reshuffling of Team Leaders during the 1st QTR and the Team Members were retained.
so I have a raw data that was already extracted for the 1st half of the 1st QTR. but the issue in my raw data is that, the UPDATED Team Leaders for each group was not carried over.

That is why I need to update the Team leader column from "Earl" to "Jose".

I can do Skype call if this would make things much faster.
just let me know the time.

regards,
Norman

[Greg_Deckler]

In the Query Editor, you can do a replace of Earl to Jose.

[ncordova]

Hi Greg,

I appreciate you for replying, I'll try this out and get back to you.
Will this be dynamic in case I'll add a new raw data that's not yet updated?

Thank you.

best regards,
Norman

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490