How to use a Record variable inside the Power Query script

Рет қаралды 3,542

Күн бұрын

List and records are important Power Query objects that you need to understand in order to fully master the M language.
This video shows a practical example of how to use a record inside of your Power Query script to add multiple columns to the table in one step.
To learn more about Power Query, check out our Power Query fundamentals course!
exceed.hr/en/academy/powerque...
#powerquery #powerbi #etltools #data #dataanalysis

Пікірлер: 15

@rauljimenez5485 3 жыл бұрын

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

@Wzxxx Жыл бұрын

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

@decentmendreams Жыл бұрын

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 .

@retamapark 9 ай бұрын

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.

@rameshep2633 2 жыл бұрын

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.

@faisalag9611 3 жыл бұрын

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

@kennethstephani692 Жыл бұрын

Great video!

@malchicken 3 жыл бұрын

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 3 жыл бұрын

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

@SaniGarba 3 жыл бұрын

Great tutorial. Thanks.

@udusegbe 3 жыл бұрын

Very good. Thanks for the tutorial 👍

@Unbox747 2 жыл бұрын

That's great!

@syedaneesdurez9880 Жыл бұрын

Amazing.. and very informative..

@allabout1135 3 жыл бұрын

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 3 жыл бұрын

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.