PQB16: Power Query Basics - Manage Queries: Duplicate, Reference or Append

Sdílet
Vložit
  • čas přidán 7. 09. 2024
  • Power Query Basics:
    PQB16: Manage Queries: Duplicate, Reference or Append
    ------------------------------------------------------
    What is the difference between Duplicate & Reference? Any relation with Append?
    An example of 3 years sales data in 3 different excel workbooks, will help us to answer the above questions. The requirement is to report the yearly sales in a number of different ways, the application of Duplicate, Reference or Append will be based on the situation and based on the report required
    ------------------------------------------------------
    To watch the full playlist
    • PQB :Power Query Basics
    ------------------------------------------------------
    To download working files:
    drive.google.c...
    ------------------------------------------------------
    To subscribe to the channel:
    / @aaaexcel
    ------------------------------------------------------
    To follow on Facebook:
    / excelispower
    ------------------------------------------------------
    To follow on LinkedIn:
    / amratef

Komentáře • 16

  • @mohamedfathy8788
    @mohamedfathy8788 Před 2 lety +1

    I can't thank you enough for this amazing series it was very informative

  • @eddieb8337
    @eddieb8337 Před 11 měsíci

    A superb series on Power Query. You obviously put a lot of thought and work into this, and it is much appreciated. I am looking forward to watching many more of your videos, they are full of great tips. Thank you.

    • @AAAExcel
      @AAAExcel  Před 4 měsíci

      thank you so much, happy that you found them useful
      appriciate if you subscribe to the new channel dedicated for English cotent
      www.youtube.com/@aaaexcelenglish

  • @juanpabloalvarezcomesana8596

    Amazing videos!
    You are a great teacher.
    I'm looking forward to watching Advanced PQ list.
    Thanks a lot for your work.

    • @AAAExcel
      @AAAExcel  Před rokem

      Thank you so much for your nice words, happy that you found it useful

  • @mohamedfawzy1661
    @mohamedfawzy1661 Před 4 lety +1

    just finished this amazing series, it was so helpful. for luck, I was preparing a dashboard for my work and I used a lot of technics I learned here.
    Thank you Mr/ amr

    • @AAAExcel
      @AAAExcel  Před 4 lety

      Happy that you like ya Mohamed - keep going 👍👍

  • @jawadahmadehssan6251
    @jawadahmadehssan6251 Před 2 lety

    Thank you for the amazing content. 👏

  • @farhankamali
    @farhankamali Před 3 lety

    Excellent series Mr. Amr. I am utilizing the skills learned from your series to my professional work. You have made PQ so simple for starters like me. Jazakallah Khair brother.

    • @AAAExcel
      @AAAExcel  Před 3 lety

      Happy that you like it and find it useful 😊

  • @royal09ruet
    @royal09ruet Před rokem

    Thanks a lot ❤the series

  • @amirabahaa4799
    @amirabahaa4799 Před 4 lety

    💪🏻💪🏻💪🏻💪🏻