List.Generate() Function and Looping in PowerQuery

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

КОМЕНТАРІ • 32

  • @joshblackman2380
    @joshblackman2380 3 роки тому +2

    Mind blown! I didn’t know M could handle this at all. Really helped me with a business problem I’m working on right now. Many thanks.

  • @taiwodaniel5340
    @taiwodaniel5340 3 роки тому +2

    Very underrated content
    Came looking for a solution to a problem
    I'll check to see if this solves it
    But thanks either way for such sharing this

  • @learnerVBA
    @learnerVBA 3 роки тому +1

    It was really interesting and well presented.
    Highly recommended...
    Regards,
    M

  • @skydeepdive
    @skydeepdive 4 роки тому +3

    Great content, clearly expressed. Keep going!

  • @sanjeevsoni6793
    @sanjeevsoni6793 3 роки тому +1

    Wonderfully explained List. Generate - Looping Function and example could be good use case

  • @mshparber
    @mshparber 4 роки тому +2

    Awesome explanation! Thanks!

  • @kebincui
    @kebincui 2 роки тому

    Great video, clearly explained. Thanks for sharing and keep posting more videos like this!👍👍

  • @iankr
    @iankr Рік тому +2

    Many thanks. In your VBA example, isn't X = 0 the staring point?

  • @kimsanov
    @kimsanov 3 роки тому +2

    Isn’t excel will start from A2 cell with your code at 1:04 ?

  • @sarthakkhanna9903
    @sarthakkhanna9903 10 місяців тому

    Good video, really helpful

  • @hamidsajjadi6783
    @hamidsajjadi6783 9 місяців тому

    very insightful. thanks

  • @malchicken
    @malchicken 3 роки тому +2

    Very good 👍

  • @DanKnight
    @DanKnight 3 роки тому +6

    Very nice tutorial...I like the detailed explainations...the only suggestion is at the early part of the video you need to revise the X=1 as the starting value for your VBA code, because your first line within the loop changes X to 2 (X+1), yet your returned result is zero.

    • @navisalomi
      @navisalomi Рік тому

      Absolutely spot on. He could also move the x = x+1 after the Range("A" & x).value.

  • @dalicodes
    @dalicodes 3 роки тому +1

    Thank you. You have saved me a bunch. I give you a like and a sub

    • @ExceedLearning
      @ExceedLearning  3 роки тому

      You're welcome! glad you found the video useful!

    • @dalicodes
      @dalicodes 3 роки тому +1

      @@ExceedLearning Yeah man I had to do api call to get data and didnt know how to loop

  • @erikbohn2771
    @erikbohn2771 4 роки тому +1

    Love it! Very detailed and well explained! Look forward to more videos. Your explanation of the syntax is very helpful too. As you mentioned it, do you have any material on handling nested records? Specifically best practices for dealing with JSON files? Perhaps in the next video?

    • @ExceedLearning
      @ExceedLearning  4 роки тому +2

      Thank you Erik! We have more videos, amidst also about nested records, in our course and plan to release some of them to the public in the upcoming weeks!

  • @humbertoibiapina5888
    @humbertoibiapina5888 2 роки тому +1

    Obrigado!

  • @mihaelstancirevic4178
    @mihaelstancirevic4178 2 роки тому

    Pozdrav, odlican video. Kako da napravim slicno, ali da imam nekakve listu vrijednosti po kojima moram u svakoj iteraciji filtrirati po vrijednostima iz liste i napraviti transformacije kako bih dobio sve retke koji cine nekakvu uredenu tablicu. Kako da stavim da se u list.generate ne stavlja recimo sheet number nego vrijednosti iz liste koje su input u napravljenu funkciju po kojoj se filtrira sadrzaj?

  • @sheetalkumardacha9432
    @sheetalkumardacha9432 3 роки тому

    First off, great video!
    I tried watching the video a couple times, but I still do not understand why the order evaluation is 1,2,4,3 instead of 1,2,3,4 at 14:35

  • @odallamico
    @odallamico 4 місяці тому

    In this case at the begining of the video, the value 1 in the VBA code is not present in the result and value 10 is present too. Nevertheless great explantion, thank for sharing

  • @MuhammadAhmed-wk4zh
    @MuhammadAhmed-wk4zh 3 роки тому +1

    Hi Informative contents.
    One request:
    Can you please share the source file with us that you used in the videos.
    It will be better for us to practice on it.
    Thanks.

    • @ExceedLearning
      @ExceedLearning  3 роки тому

      Hi, you can find the files we used in the video in the article on Exceed website. Link to the article is in the video description.

  • @__HumanBeing
    @__HumanBeing 2 роки тому

    Oscar de la Hoya is very good at M language!

  • @bluex5115
    @bluex5115 2 роки тому

    lololll .. r u real ? range A1 will be populate with 1 ? start with x=1 add 1 x=x+1 and u start with 1 on A1 ? loooool A2=2 is i fiirst point