How to use a Record variable inside the Power Query script

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

КОМЕНТАРІ • 15

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

    Your PQ skills are superb. Highly advanced and topical. I used to skip your vids a year ago because it was too advanced but now that I am more comfortable with PBI I am beginning to appreciate your vids . Thanks .

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

    I love it when I find such simple, elegant and POWERFUL tutorials. Thank you very much!!!

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

    Love the way you explain. Very helpful. Came across similar problem where I used to duplicate the query and get the job done. This technique was quite helpful, thanks.

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

    Very clearly explained! Thank you. I have the need for this sort of thing when working with Excel files downloaded from accounting systems. This is much more elegant than what I was doing.

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

    Very clear and informative and helpful, thank you :) I’ll need to check out other videos, but more videos distinguishing: “how to solve this problem using a record, vs a list, vs a table or which method *is best* for any given problem, is much appreciated”. It’s a bit difficult for me to understand when to apply one of those over the other.
    Btw, please consider making all your videos into a playlist; it makes it easier to binge watch them all at once, thank you!

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

      Thank you Hendrick!
      We had that in mind, just waited to acquire more videos before creating a list. Guess now's the time!

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

    That was helpful. Simple and clear.
    Thanks for sharing.

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

    Great video!

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

    Amazing.. and very informative..

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

    Great tutorial. Thanks.

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

    Very good. Thanks for the tutorial 👍

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

    That's great!

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

    Oh man, this was interesting for me as I have similar challange, but I have additional 2 tables and below the main table. Can it be solved by this method? Thanks in advance.

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

      Yes, it can be solved by this method. You can try to get to 2 records in a way that is described in the video, and later combine the two records with the Record.Combine() function:
      RecordDetails = RecordCombine({Record1, Record2})
      After this, you can use the newly created record to add a custom column to your main table.

  • @Wzxxx
    @Wzxxx Рік тому +1

    Thank You! This was exectly what I was looking for! So grateful. thx