APQ15 | How "each" & "_" work? | Advanced Power Query

Поділитися
Вставка
  • Опубліковано 27 лис 2024

КОМЕНТАРІ • 40

  • @osoriomatucurane9511
    @osoriomatucurane9511 6 днів тому

    Awesome tutorial, compreehensivel, concise and crystal clear. You have nailed the concept. I had to play the tutorial many times for days and practice to get the hang of it. Well done, Sir. You are truly M Code Legend and you absolutely master the state of art in teaching.
    I salute you. Keep it up.

  • @LaloinLondon
    @LaloinLondon Місяць тому

    Very clear. Straight to the point. You deserve more subscribers, and we deserve more videos from your channel.

  • @brianxyz
    @brianxyz 5 місяців тому +1

    Excellent video with great examples. Appreciate that you zoom in and make your screen nice and clear. Being able to see the code on the screen helps a lot. Thanks!

  • @roywilson9580
    @roywilson9580 5 місяців тому

    One of the most useful of the functions available in the M language, especially when combined with a nested let statement. Thanks for the clear and concise video explaining the uses and syntax, I wish that there had been such a video when I was learning this syntax!

    • @aaaexcelenglish
      @aaaexcelenglish  5 місяців тому

      Glad that you found it useful, thank you so much for your comment

  • @aijazali8926
    @aijazali8926 4 місяці тому +1

    Thanks for sharing such a nice series of Videos in a simple way, it would be helpful for person like me who do not have resources to purchase entire course. Thanks!

  • @peggychen3411
    @peggychen3411 2 місяці тому

    Amazing video, explain so clearly, very useful.

  • @rameshep2633
    @rameshep2633 Місяць тому

    Explained beautifully... Easy to understand. Thanks

    • @aaaexcelenglish
      @aaaexcelenglish  25 днів тому

      Happy that you found it useful, most welcome 🙏

  • @KuldeepSingh-nq1vi
    @KuldeepSingh-nq1vi 2 місяці тому

    Great Video, I learnt new thing, Thanks for creating such wonderful video.

  • @seamushand8439
    @seamushand8439 27 днів тому

    Very well explained. Thank you

  • @KumarAnalytic
    @KumarAnalytic Місяць тому

    In a folder I've so many Excel files and want to load into power query in one go as different data like Sales, Payroll, Attandance, Returns, Product etc. here I just want to load and I don't want to combine it.
    Thanks a lot AAA EXCEL English!!😮😮😊😊

  • @houstonsam6163
    @houstonsam6163 2 місяці тому

    Excellent, clear explanations. Many thanks.

  • @anaezechinedu1399
    @anaezechinedu1399 3 місяці тому

    you are absolutely the best...

  • @josh_excel
    @josh_excel 5 місяців тому

    Very good approach by starting with a simple example and moving to more complex ones.

  • @kebincui
    @kebincui 5 місяців тому

    Excellent video that brings home the key concept of this each _ unnamed custom function ❤👍

  • @Ypurenete
    @Ypurenete 5 місяців тому

    Great explanation. Thanks a lot. Congrats!! Hugs from Amazonia (Brazil)

  • @sasda1234s
    @sasda1234s Місяць тому

    Amazing explanation!

  • @jazzista1967
    @jazzista1967 5 місяців тому

    Amr... this was a great video... you debunked the each_ conundrum. I will have to re-watch it again. Thanks for sharing

  • @zahoorsarbandi2982
    @zahoorsarbandi2982 5 місяців тому

    amazing. thank you sir

  • @eduardomunoz2764
    @eduardomunoz2764 5 місяців тому

    Great video, greetings and thank you teacher.. Greetings from Mexico

  • @damilolalasode4381
    @damilolalasode4381 5 місяців тому

    This is a very good video. However, there are also instances when (substring)=> is used in place of each and _ in order to deal with ambiguities in the List.Transform () function. Please can you do a video to explain this. I will be really grateful if you do a video tutorial on this issue.

  • @leetran8328
    @leetran8328 3 місяці тому

    tks

  • @boissierepascal5755
    @boissierepascal5755 5 місяців тому

    🎉👏🏽👏🏽👏🏽