Forum Discussion

ncordova's avatar
ncordova
New Member
8 years ago

NEED HELP with Power BI query optimization

Hi Guys,

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

 

 

 

 

 

 

 

 

 

 

Thank you and best regards,
Norman

5 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi ncordova,

     

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

     

    Regards,

    Yuliana Gu

    • ncordova's avatar
      ncordova
      New Member

      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's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

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